Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

number format error message

Posted on 1998-11-10
3
Medium Priority
?
238 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
ID: 1614424
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
ID: 1614425
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 80 total points
ID: 1614426
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

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft has changed the look and feel of Azure AD and Microsoft account sign-in pages so that you will have a more unified look and feel when moving between the two interfaces.
Lost Word File? Eagerly, need it back? Read ahead; this File Recovery guide is for you.
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

927 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