Excel 97 Formatting error

  • Thread starter Thread starter Anup Bhole
  • Start date Start date
A

Anup Bhole

Hi everybody
when I open a excel spreadsheet I get the error, "No
more custom Number Formats can be added".

The excel file itself is not big. Also the behaviour is
different on different machines having the same version
of Excel ( Excel 97 SR2(k) Japanese/English)

Any clues ?
 
Anup Bhole said:
Hi everybody
when I open a excel spreadsheet I get the error, "No
more custom Number Formats can be added".

The excel file itself is not big. Also the behaviour is
different on different machines having the same version
of Excel ( Excel 97 SR2(k) Japanese/English)

Any clues ?
Click to expand...

Take a look here:
http://www.j-walk.com/ss/excel/eee/eee007.txt
About half way down you will find an excellent macro by Leo Heuser for
deleting unused custom formats. I have used this several times, always
successfully.
 

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

Similar Threads

"Excel encountered an error and had to remove some formatting toavoid corrupting the workbook. Pleas 0
Excel 97-03 compatability with Excel 2007 1
working with excel 97 workbooks 5
Excel 2007 crashes when perform SAVE AS to Excel 97-2003 0
Saving Custom number formats 1
error on opening .xls 3
Conditional Formatting 1
Problem Opening Excel 2003 Documents 1

Back
Top