Too many different cell formats

[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

 

[Kent]

It may be possible to deal with this but I would need the
file.

Excel Support Technician
www.canhelpyou.com

 

[Peter Dwyer]

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.

 

[Dave Peterson]

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