Too many different cell formats

[George W]

I am working with a large spreadsheet (with many
worksheets) that will not allow me to change/add any more
cell formats and limits my additional data entry. The
message pops up "Too many different cell formats".

Per Microsoft's support page 213904, they instruct you to
reduce the number of formats to standard formats, etc.
I've tried to do that but any change backwards to standard
formatting is evidently the same as new change. I'm stuck.
There must be a trick to quickly change each worksheet
back to a standard format.

Any help would be appreciated.
Excel 2003on Windows 2000

Thanks.
George

 

[jeff]

Hi,

My guess is that you'll have to copy portions out to a
new set of workbooks to make "room" for even the changes
you mention.


jeff

 

[Dave Peterson]

Some people report that OpenOffice can make fixing this easier.

http://www.openoffice.org, a 60-65 meg download or a CD

 

[Dave Peterson]

And when I had to fix one of these things, I did it bit by bit.

And each time I was able to fix a range, I had to save, close and reopen.

(but it was a little while ago.)