Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

no more custom number formats can be added error

Status
Not open for further replies.
Wazzer

Wazzer

MIS
Aug 6, 2001
17
0
0
GB
One of our users has been sent an XL97 file which when opened gives a 'no more custom number formats can be added' error.

Does any know what this means. A search of TechNet comes up with very little.
 
Sort by date Sort by votes
It means there are too many custom number formats set up in that workbook
You will need to go to Format>Cell>Number>Custom and delete some of the additional Custom number formats

K :)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

renigar
  • Question
Excel Power Query refresh error
Replies
3
Views
361
SoftwareRT
SoftwareRT
renigar
  • Locked
  • Question
Excel custom format data validation 4
Replies
13
Views
171
Deniall
Deniall
foxmuldr3
  • Locked
  • Question
Does anyone ever see this error in
Replies
1
Views
94
Andrzejek
Andrzejek
Tonyqu
  • Locked
  • Question
Automation Error
Replies
2
Views
81
strongm
strongm
kwbMitel
  • Locked
  • Question
I can't add sheets to my Excel file because it's protected.
Replies
4
Views
479
StilLearningAlot
StilLearningAlot

Part and Inventory Search

Sponsor

Back
Top