I've run into this limitation on a large weekly report that I do. The unfortunate thing is that I've completed this week's report (after 12 hours of work) and now can't open the file. I'm using Excel 2000. Every time I try to open the file, I get this error. I've tried moving it into a ZIP file, setting it to 'read only', copying to a new file, and doing a 'view only'. Nothing works, I am not able to open the file. Any ideas how I can recover my work?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
"Too many different cell formats"
- Thread starter bholeman
- Start date
Hi - welcome to the board!
the underlying problem is probably this:
http://support.microsoft.com/default.aspx?scid=kb;en-us;213904
...what version are you using?
the underlying problem is probably this:
http://support.microsoft.com/default.aspx?scid=kb;en-us;213904
...what version are you using?
Upvote
0
Mark O'Brien
MrExcel MVP
- Joined
- Feb 15, 2002
- Messages
- 3,530
The only solution I have found for this problem is to download openoffice.org 1.0 from the aptly named website:
www.openoffice.org
This is an Open Source suite. The spreadsheet application has different limitations to Excel and is able to open Excel files that even Excel cannot open. I'm not sure if Excel 2002's excellent file recovery feature would be able to open the file.
once you have the file opened in openoffice.org, you can manipulate it however you need to to allow Excel to be able to open the file.
www.openoffice.org
This is an Open Source suite. The spreadsheet application has different limitations to Excel and is able to open Excel files that even Excel cannot open. I'm not sure if Excel 2002's excellent file recovery feature would be able to open the file.
once you have the file opened in openoffice.org, you can manipulate it however you need to to allow Excel to be able to open the file.
Upvote
0
That worked!! Thanks for the help. I've been on the Tech24 help line for the last 6 hours and to this point, they've not been able to get the file open yet. I suspect they will eventually, but they haven't managed to yet. (I live in CMH too.)
Upvote
0
Mark O'Brien
MrExcel MVP
- Joined
- Feb 15, 2002
- Messages
- 3,530
bholeman said:
You poor sod.
At least someone is sharing the same bad weather as me today.
Upvote
0
Similar threads
- Question
- Solved
- Question
