A page format is a combination of upper/lower/left/right border, font color, interior color,
number format. All the more reason to format large areas all at the same time instead
of individually. You will have to remove a format, then you run Leo Heuser's macro,
not the one in EE but one he posted later.
..
If you had searched the Excel newsgroups with the content of at least the first line from the
message you got you would probably have the solution yourself.

http://www.mvps.org/dmcritchie/excel...sp.htm#formats

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Richard Bailey" <Richard wrote in message
...
When trying to load an excel file it will not allow me to open it and shows
the message in a separate window " too many different cell formats".
I am led to believe (after a bit of investigation) that the file is now too
large and needs to be slimmed down. This is fine, but I need to be able to
open it first! Is there a way to open this file?
Please help. This spreadsheet is important to me. Thank you.