error message: Too many different cell formats.

I wanted to ask if I have an excel file with multiple sheets and this error 
message comes up is it ok if I take the sheet I was trying to do work on, 
send it to a new excel file "eg. book1" and then work on it?  And if I do 
this can I put the sheet  worked on back into the excel file i took it out of 
without getting that message?  
Vince Hill
Vinceburg (1)
8/11/2005 2:01:02 PM
excel.misc 78881 articles. 5 followers. Follow

2 Replies

Similar Articles

[PageSpeed] 40

Here is a Microsoft Knowledge Base article about that:;en-us;213904

This happens in large spreadsheets that are format-intensive.  Excel
can keep track of about 4000 different combinations of formats; beyond
that you get the error message.  I have corrected this in large
workbooks by deleting unused sheets and by going to infrequently used
(but mission critical) tabs within the sheet and setting them to a
neutral format: no font color, no background color, no
left/center/right alignment, no patterns, no boxes.

CycleZen (674)
8/11/2005 2:11:19 PM
Some info:

XL: Error Message: Too Many Different Cell Formats

A few people have posted that they could open the file in OpenOffice, then
remove some of the formatting, save it and then excel would open that file ok., a 60-65 meg download or a CD

But I would think your suggestion would depend on how many different formats are
in the workbook and how many different formats are on that sheet.  (you won't
know until you try.)

Vinceburg wrote:
> I wanted to ask if I have an excel file with multiple sheets and this error
> message comes up is it ok if I take the sheet I was trying to do work on,
> send it to a new excel file "eg. book1" and then work on it?  And if I do
> this can I put the sheet  worked on back into the excel file i took it out of
> without getting that message?
> --
> Vince Hill


Dave Peterson
petersod (12004)
8/11/2005 2:18:43 PM

Similar Artilces:

Sending entire objects via socket vs primitive message fields
I am using a library called "The Network Development Kit". The kit allows me to easily establish client/server connections and assemble "messages" (consisting of strings, integers, etc) to pass back and forth between the client and server. With my initial protocol design, I have been passing data via the primitive data field types (strings, int's, etc). The basic logic flow requires me to: 1) Deconstruct the object and assemble the varying field values into a CNDKMessage. 2) Send that message to the server and reconstruct th...

Excel Progrom Error
Hi there Happy new year to all. I often receive the folowing error message in a box titled "Program Error". EXCEL.exe has generated errors and will be closed by Windows. You will need to restart the program. An error log is being created. The only option is OK which closes Excel. I do not know where the error log is created. I am using Office 2000 Service Pack 3 with Windows 2000 Professsional Service Pack 4. Can anybody throw some light on this error. Thanks in anticipation. Michael What are you doing at the time (i.e. is it consistent)? -- Regards; Rob ----------------...

Setup of Generic Out of office Message office 2003/2007
Hi, Out Communications department want's us to setup a standard out of office message for all mailboxes in the organisation. They want every user to have access to the generic Out of Office message. Is there a way I can create an Outlook template or something that I could give all users to put in their mailbox Out of Office area. thanks -- Kath ...

Value in a cell is sum of one or more other cells
Hi all, I have a column of cells containing positive and negative values. I want to find those cells which equal the sum of 2 or more other cells. I have no VBA experience. Many thanks, Colin -- karabiners ------------------------------------------------------------------------ karabiners's Profile: View this thread: ...

Sharebuilder account import error
Invalid .qif header error when trying to import .qif file from sharebuilder accounts. Anyone know of a fix or experienced this problem?? I typed a long mail to sharebuilder regarding this issue...still waiting fora reply. Hopefully they will be able to help. Microsoft flat out told me it wasn't their issue and to contact my broker! No help AT ALL. Microshaft..... OMalley ...

Messages saved to Deleted Items instead of Drafts
I am using Outlook 2003 SP2 (Office 2003 Pro) in Windows XP Pro SP2, with all available patches to Windows and Office. If I start a message or a Reply and click the Save icon, the saved message is "saved" to the Deleted Items folder instead of the Drafts folder. If I close the message (as one would do if one were planning to continue later) and empty the Deleted Items folder the message is lost. If I go to Tools, Options, Preferences, E-mail Options..., Advanced E-mail Options..., "Save unsent items in:" has "Drafts" selected, so it should save them in the...

Select range of cells in column AS based upon lastcell in col A.
I need to select a range starting from the active cell 9 in column AS and a variable number of rows down based upon last entered cell in column A. Does anyone know how to go about doing this? try Range("AS9:AS" & Cells(Rows.Count, "A").End(xlUp).Row).Select or do you mean upto ColA Range("AS9:A" & Cells(Rows.Count, "A").End(xlUp).Row).Select If this post helps click Yes --------------- Jacob Skaria "jonnybrovo815" wrote: > I need to select a range starting from the active cell 9 in column AS and a ...

DPM2010 RC Errors on secondary server.
We have recently upraded our 2007 SP1 Primary DPM server to 2010 RC and it is working perfectly. I've set up a brand new, fresh Windows 2008 R2 Server for the secondary server, and have told it to protect one of the protection groups on the primary server. Everything works for a little while, but every half hour or so, the DPM service crashes and says: "Connection to the DPM service has been lost. Review the application event log for information about a possible service shutdown. ID: 917" Then asks to restart the administrator console. This kills the ...

Hi I am using a spreadsheet in Excel 2002 on Windows XP, for some reason the account numbers (which someone input, along with addresses) have a little green mark in the corner of the cell. I thought it was to show that there is a comment, but it is not. When you click on the cell, a little warning sign shows, saying ERROR - number in this cell formatted as text or preceded by an apostrophe. When I click on the arrow by the warning sign, it says Number stored as text Convert to number Ignore error Edit in formula bar Error checking options Show formula in audinting toolbar Now I looked a...

error, chkdsk
Questio, when I try to open excel or winmx, an error pops up saying chkdsk, so i ran a chkdsk and it doesnt do anything. The error also says corrupted file. In excel I have some important work that I need to open, and it only opens in Turkish, if I change it to English, its a bunch of boxes and letters, its not my work I need. How do I change it back. What excel version are you using? Try to find somebody with 2003 to see if they can open the file. Otherwise you would look for some commercial software that might be of help

html format email
How can I, if possible, create html formatted email and/or email templates in crm? I can write some custom add-ins in c# if needed. Thanks, J On Sat, 26 Feb 2005 08:41:24 -0500, "Scanner2001" <> wrote: > How can I, if possible, create html formatted email and/or email >templates in crm? You can create html email templates. The secret is to create them in another tool eg Notepad or Dreamweaver then open the html in IE and then cut and paste into the CRM email template window If you have graphics only links to the images are copie...

4.4.7 error
I have problems on one client that they don't recieve all emails from people sending to them. I guess something is wrong in the configuration. When I do a nslookup -type=mx I just get unautharized answer. Also the ttl time is just 1800 when I do a dns report. Do the guys that handle the dns change this? The people that doesn't get their mail throw get the 4.4.7 error in return. Best regards Jimmy -- Ed Crowley MVP "There are seldom good technological solutions to behavioral problems." .. "Surfer&q...

error 0x800CCC0F
Dear Team; I am receiving the following error messages, please assist Could result be sent to regards Lew Your server has unexpectedly terminated the connection. Possible causes for this include server problems, network problems, or a long period of inactivity. Subject 'brocolli & mushroom stir fry noodle', Account: '', Server: '', Protocol: SMTP, Port: 995, Secure(SSL): Yes, Error Number: 0x800CCC0F Your server has unexpectedly terminated the connection. Possible causes for this include server p...

delete server...routing master error
hello, I have 2 exchange servers (exch 2003) and i have to delete one of them. I changed all replication etc...(before we had also a 5.5 which is already removed) but when i stop the services and try to remove the server via system manager of my second exchange (the one that will stay) i get an error message that my server that i want to delete is the routing master for that group. How can i make my other server the routing master ? i don't have any site replication (deleted it because not necessary anymore). thnx, Philippe Go to routing groups > first routing group > mem...

Excel error codes translations
hi, Does anybody know where I can find a kind of dictionary for Exce errors? The problem is sometimes I get an error message that is not in Englis and without error code and then looking for the solution I must kno its equivalent in English. Regards, Micha -- Message posted from ...

toolbar, date, services, errors, paste, minimized system restore doesn't work
I have a XP system that the toolbar does not show open programs, services do not seem to load at boot, the date is off by one month, I cannot paste anything that I copy, and system restore does not work. All of these issues started at the same time a few days ago. Has anyone else seen this group of errors? I am trying to resolve and do not know if it is a system update gone bad, or if maybe it is a viruse/malware issue. Please let me know if you had had these problems together and what you did to fix them. There is a very good chance that you are seeing the effects of a hi...

set up different default printer for MS Excel
I have a printer A set up as default for my PC. I want to have a printer B to be default one for ALL NEW Excel files. So task is not to change it manually or via some macro button; the task is to have the printer B ready directly after opening of Excel file. Any suggestions? Stefan, You can change the default printer for all applications with the Windows Control Panel. Start - Control Panel - Printers and Faxes. Right-click the printer you wish to be the default, and choose "Set as Default." To set a default printer for Excel only (different from the Windows default printer...

Can you link many workbooks to one template? And Update?
I tack around 100 different workbooks. All are the same "template"; however, I often update the formulas and therefore must go back to each workbook and update them formulas. Is there a way to link all of the workbooks to a "template" to calculate the formulas? And can I change the one template formula so all the workbooks are updated at once? ...

Re: Money 2004
Thanks for the suggestion. I tried unregistering/re-registering the msxml3 DLL, but still no luck. However, knowing the help file topics are local might help with debugging this problem. thanks, randy "Randy" <> wrote in message news:... > All, > > I've recently upgraded to Money 2004 Premium from 2003 Deluxe. I'm now > finding that I can't view any help topics--I get the "Unable to load topic. > Click here to try again." I've tried all the suggestions posted here and at > other sites: cleared out temporary in...

"Remotely" Change Cell Values
Hey gang - I've developed a deer population model (1 for each of 88 counties) to track herd size from 1981 to present. I start with an initial population estimate (in 3 male and 3 female age groups) in 1981 and each year add births and subtract known mortalities (aka harvest). I also make some estimates of non-harvest losses and nonreporting (people who harvest but do not report). Any how, if I've got all the parameters (birth rates, survival estimates...) right and I've done a good job of accounting for all mortality, I should be able to generate a fall population estimate e...

"File Error: Data May Be Lost" error when opening workbook saved in Mac
When I open in Excel 2007 for Windows workbook with charts saved in Mac OS, I see the message "File Error: Data May Be Lost". In Excel 2003 for Windows this message appears as many times as many sheets there are in workbook. Maybe someone knows what's the reason? Unfortunately you haven't provided the info needed... "Mac OS" means very little. The question is "What version of Mac Excel are you using, what file format are the files saved as & what type of content is in the files?" In general, what you're running into is that Excel 2003 &a...

Repeating cells
With a 1 in A1, a 2 in B1, and a 3 in C1, if I click on C1 and drag the handle the D1, Excel increments the value to 4. Is there a way other than Control C to cause D1 to be 3 (the same as C1) instead of 4 (C1+1)? Excel 2000 If you only select c1 and drag the handle to d1 it will repeat "3". Regards Bill K "mcp6453" <> wrote in message > With a 1 in A1, a 2 in B1, and a 3 in C1, if I click on C1 and drag the > handle the D1, Excel increments the value to 4. Is there a way other > than Control C to c...

Technical error
AMEX and Discover are not being sent over to the credit card processor during settlement. I comes up with a "TECHNICAL ERROR". Visa and MC are settling fine. Does anyone know what the problem is?? All are setup as different tranaction types in RMS and ALL authorize fine during the transaction process. Your merchant account is not correctly configured for AMEX & Discover. This is on the bank's side, not RMS. -- Glenn Adams Tiber Creek Consulting ---------------------------------------------- Please DO NOT respond to me dir...

How do I format text as a hyperlink in Excel
I want up to 1,00o cells in a single Excel worksheet to display as hyperlinks to general web addresses (mainly home pages). Each cell is a different web address. How do I format the Excel cells to display and act as a hyperlink? The formula to use is =HYPERLINK(actual_address, friendly_address) where actual_address is the full link to the website (or other excel sheets/files), and friendly_address is what is shown in the Excel cell - underlined and coloured blue. If friendly_address is missing, the actual_address is shown. Hope this helps. Pete Pete Thanks for this BUT I already hav...

CObject Private method access error
Hi, I am trying to recompile application that has been developed in VC++ 6.0 with VC++2005.. While compiling, I'm getting the following error.. error C2248: 'CObject::CObject' : cannot access private member declared in class 'CObject' 1> c:\program files\microsoft visual studio 8\vc\atlmfc\include\afx.h(553) : see declaration of 'CObject::CObject' 1> c:\program files\microsoft visual studio 8\vc\atlmfc\include\afx.h(524) : see declaration of 'CObject' 1> This diagnostic occurred in the compiler generated function 'CExcepti...