Too Many Formatted cells


G

Guest

I have workbook that has approx 25 sheets in it. It is a graphically extensive workbook and now I get the message too many formatted cells and the workbook won't open. If I go to an earlier version, and try to lose some of the formatting. it counts them as new formats and I hit the wall again. Any ideas?
 
Ad

Advertisements

R

Robert Rosenberg

Are you using custom number formats and/or styles? Try eliminating the ones
you know you're not using (Format-->Cells-->Number Tab-->Custom Category).
In addition, copying and pasting between workbooks copies styles and the
list can get very large. Use the Format-->Style command and delete the ones
you're not using.

Even if you're using all of them, you may have the same style more than one
time (but with different names). For example, if I copy a worksheet from one
workbook to another workbook and the styles being used have the same name
but different formats, Excel copies in the styles but adds the name of the
workbook to the end of the style name.

Ex: Copy Sheet 1 from a workbook called Test.xls to workbook
Destination.xls. The Normal style from Test.xls appears in Destination.xls
as Normal_Test.
--
_________________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel
http://www.r-cor.com


Marti N said:
I have workbook that has approx 25 sheets in it. It is a graphically
extensive workbook and now I get the message too many formatted cells and
the workbook won't open. If I go to an earlier version, and try to lose
some of the formatting. it counts them as new formats and I hit the wall
again. Any ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top