Archive of Mr Excel Message Board

Back to Errors in Excel archive index
Back to archive home

Excel 97 on Win 98

Posted by nelson on January 31, 2002 8:26 AM

I am getting an error message, "Too many different cell formats". Can anyone tell me what the problem is? I try to format anywhere in the cell and it gives this error message

Re: Excel 97 on Win 98

Posted by Chris D on January 31, 2002 3:01 PM

there were a few previous posts in the archive something similar to this...... from memory, there are just too many different formats in your spreadsheet.... is it full of boldings, italics, colours, different decimals, number formats, date formats, left-alignments, borders etc etc etc?

try stripping a few large ranges of un-neccesary formats.....

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.