Too many different cell formats

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Recently, while working with a large Excel 2000 workbook,
I encountered an error. The error read "Too many
different cell formats." After clicking "OK" I saved and
closed the workbook.

Unfortunately, now, my workbook will not open!!!
Microsoft's fix posted on their website is to reduce the
file formats in the workbook. However, once you've closed
the workbook, it is impossible to open it again.

Does anyone know of a fix for this problem. My last
backup file is over two weeks old!!!

Thanks,

Mike
 
You could try importing the data on your old workbook
into a new workbook - that will obviously depend on your
layout and the actual data itself.

Alternatively you could try importing into MS Access etc,
or even opening the workbook with a later version of
Excel, this has worked more than once before now.
 
See one reply at your first post.
Recently, while working with a large Excel 2000 workbook,
I encountered an error. The error read "Too many
different cell formats." After clicking "OK" I saved and
closed the workbook.

Unfortunately, now, my workbook will not open!!!
Microsoft's fix posted on their website is to reduce the
file formats in the workbook. However, once you've closed
the workbook, it is impossible to open it again.

Does anyone know of a fix for this problem. My last
backup file is over two weeks old!!!

Thanks,

Mike
Click to expand...
 
Back
Top