Solved

number format error message

Posted on 1998-11-10
3
230 Views
Last Modified: 2012-08-14
Hello all,

Can someone tell me what these error messages mean and how can I fix them?

"No more custom number formats can be added!"
This error message appears when I first open an Excel file; I have to click OK several times before it goes away.

"File Error, Some number formats may have been lost"
After clicking OK on the first error message, then I get this one I click OK once and it goes away, then I can work on my file.

The messages only appear when I open an existing file; they do not appear with a new file.
Can someone please help?

TIA, Jovix
0
Comment
Question by:Jovix
3 Comments
 
LVL 5

Expert Comment

by:jboddy
Comment Utility
Which vesion of Excel?
Most seem to favour this solution:-
"You receive these error messages if the Symbol box in the
International - Currency Format dialog box is empty."
Will re-post as an answer if it solves the problem.

0
 
LVL 5

Expert Comment

by:vboukhar
Comment Utility
Did this messages appear on every files, or just on some of them?
Maybe this workbook really contains custom number formats?
0
 
LVL 2

Accepted Solution

by:
cartti earned 20 total points
Comment Utility
In this file, choose the Format Cells option. In the Number category, check the sub-category custom. If it is a huge list of formats, the error message was referring to the size of this list. If you delete the unnecessary ones and then save the file, you should no longer get those error messages.
The reason why you don't get these messages with a new workbook is because settings which include custom number formats are saved with the file. Basically Excel is having memory problems storing all those formats which might explain the loss of some of them.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Have you ever had the experience that you had to follow 10 steps over and over again every time when you need to nicely forward an important email to your manager? Fear no more! With the help of the Quick Steps feature in Outlook 2010, your old chor…
Introduction It seems that at least a couple of times per month, I answer a question that requires automating Outlook from another Microsoft Office application, usually (although not always) to send one or more email messages.  For example: …
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses. Navigate to the “Start Mail Merge” button in the Mailings tab: Follow the step-by-step process until asked to find the address doc…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now