Too many different cell formats

[Neil Green]

A user received the message "too many different cell
formats" on a worksheet they had been using for a long
time. They deleted all formats and still got the same
message. Eventually they deleted all the data and still
got the same message and when they looked at file size it
was 289kb. What can cause an entirely blank workbook to be
so large? Can anybody let me know?

 

[Frank Kabel]

Hi Neil
for dealing with too many cell formats have a look at the following KB
article
http://support.microsoft.com/default.aspx?scid=kb;en-us;213904


For clearing the used range (and therefore shrinking the file size)
have a look at
http://www.contextures.com/xlfaqApp.html#Unused

 

[Neil]

Thanks for the reply but there is no data in the sheet at
all. Pressing CTRL - END just brings it to A1.

It's something in the background. I think.

Neil Green. IT support. Goldsmiths Group.

 

[Frank Kabel]

Hi Neil
maybe some hidden object. Trys
- hit F5
- choose 'Special'
- choose 'Objects

and see if there're any object within your file

 

[Neil]

Frank,

Thanks again for the assistance.

I've tried what you suggested but it comes back with "no
objects found". Tried most of the other ones in that
screen too but didn't find anything.

Thanks again,

Neil.

 

[Frank Kabel]

Hi Neil
if you like email me your blank file and I'll have a look at it - no
guarantee - though :-9

email: frank[dot]kabel[at]freenet[dot]de