Too many different Cell Formats

  • Thread starter Thread starter GORD
  • Start date Start date
G

GORD

I am getting this error, my spreedsheet are quit large and
has been evolving to this level since 1998.
I know that exel has a maximum of 3000 formats, how can I
increase this or how can I keep adding to my spreedsheet.

HELP PLEASE!!!
 
Hi "GORD"!

See:
http://support.microsoft.com/default.aspx?scid=kb;en-us;213904&Product=xlw2K

Also thanks to a Google search, I found the following posting by Dave
McRitchie:

Leo Heuser has a macro that you can find in the 7th issue (eee007)
http://www.j-walk.com/ss/excel/eee/eee007.txt
of the Excel Experts E-letter to remove unused custom number formats.
The EEE newsletter is maintained by David Hager (MVP-Excel). (link to
revised code below)

Leo posted a macro 2001-05-06 in programming as a very
major revision of the macro in the eee007 article.
http://groups.google.com/groups?selm=OxP9cgi1AHA.1572@tkmsftngp02


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top