Office 2007 Styles create issue with "Too many different cell form

I'm not sure if anyone has come across this issue. I have a file that is used 
by both 2007 and 2003 users. Everything was working fine until one day the 
2003 users were getting "Too many different cell formats."

The issue was that there were now 3000+ styles on the spreadsheet. There 
were now custom styles created for each of the new cell styles in 2007 like 
the accents. It looks like everytime this was saved in compatibility mode, 
this was turned into a custom style. Eventually there were Accent1, Accent 1 
1, Accent 1 2, etc.

This looks like it will continue to be an issue in all sheets unless these 
are removed in the first place.

Is there any way to completely disable the new styles from loading in any 
worksheet while leaving specific ones like Normal and Comma?
0
Utf
12/16/2009 8:46:02 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
552 Views

Similar Articles

[PageSpeed] 44

Thousands of unneeded/unused styles seems to be a feature of XL2007.
You should be able to automatically delete those unused styles with my free Formats & Styles Excel add-in.
Download from... http://excelusergroup.org/media/
If you give it a try, please post back with your results.
-- 
Jim Cone
Portland, Oregon  USA



"RyanAtWork" <RyanAtWork@discussions.microsoft.com> 
wrote in message news:77D51512-7F4C-4E0B-BCED-C43254F3494B@microsoft.com...
I'm not sure if anyone has come across this issue. I have a file that is used 
by both 2007 and 2003 users. Everything was working fine until one day the 
2003 users were getting "Too many different cell formats."

The issue was that there were now 3000+ styles on the spreadsheet. There 
were now custom styles created for each of the new cell styles in 2007 like 
the accents. It looks like everytime this was saved in compatibility mode, 
this was turned into a custom style. Eventually there were Accent1, Accent 1 
1, Accent 1 2, etc.

This looks like it will continue to be an issue in all sheets unless these 
are removed in the first place.

Is there any way to completely disable the new styles from loading in any 
worksheet while leaving specific ones like Normal and Comma?
0
Jim
12/17/2009 3:48:53 AM
Reply:

Similar Artilces:

issue with accessing methods of an activex control written in vc++6
hi there i have written a very simple activex control in vc++6, the project was created using the standard ActiveXControl MFC wizard, and i added one automation method using classwizard i embed this activex control in a web page, which is to be part of a dialog box of a vc++6 app (i use IWebBrowser2 to do this) i try calling the automation method from within javascript contained in the web page, but it always fails! ie var o = new ActiveXObject("progid"); // o is created ok o.method(); // fails if (o.method) // also fails { .... } i haven;t done much activex stuff bef...

Using 2 versions of Mac Office 2004 (Japanese and English). How do I set the default for which version my machine uses to open office files?
I using 2 versions of Mac Office 2004 (Japanese and English). How do I set the default for which version my machine uses to open office files? It would of course be better if MS allowed users to switch menu languages within the program just as Mac does with its OS and associated software. But since that is not the case, I have had to purchase install the English version of Office 2004 (at great expense both monetarily and memory wise). When I open files already on my computer it always opens them with the "default" version of Office 2004 which is in Japanese. I can't seem to ...

Outlook 2007 DST/Time zone issue
I have a network with 4 computers running Office 2007, XP Pro connected to SBS2003. Outlook is connected to the Exchange 2003 component of SBS2003. Computers were deployed using a single, new image inside the last 3 months. New Zealand has had changes to the daylight savings change over dates, and as part of this process the required Microsoft Updates were deployed to the workstations, using WSUS, and applied to the server. Two of the computers have no problem, while two have an issue where calendar entries are 13 hours out. They appear to be defaulting to GMT, instead of NZT (GMT +1200)...

Out-of-office twin replies
I've seen some posts here with regards to OOO replies generating two replies, one of which is blank. This is happening on at least two different versions of Outlook and Exchange 5.5/2000 so it appears to be a server side problem. Does anyone have a solution to this? ...

Customization to a Contact Form Does NOT Stick
Everytime I try to add a field in a Contact form, the change does not stick. I have administrator rights, followed the instructions to customize a form to the t. The instructions entailed going to: Home -> Settings Settings tab -> System Customization Record Management -> Contacts Add Fields -select fields to add ok - > save work On the CRM server Start -> Programs -> Microsoft CRM -> Deployment Manager Right click: Deployment Manager -> All Tasks ->Publish Customization Select form customized Add Finish OK Restart IIS After performing these steps, I get b...

Sorting with empty cells
I have the following data: 1 blank 4 blank and I want to sort it as: 1 blank (position 2) blank (position 3) 4 When I sort, I end with: blank or 1 blank 4 4 blank 1 blank Basically, the value of the cell should be the position in the sorting data. Any help will be greatly appreciated. Thanx. ...

Vista
I have just purchased a PC with Windows Vista already installed, and have installed Microsoft Office 2003 on it & registered it. However, whenever I launch Excl I am confronted with a screen showing a Microsoft Office End Users Licence Agreement which requires me to agree to each time before the programme will launch. Does anyone know how to stop this happening? You registered but did you activate? Gord Dibben MS Excel MVP On Thu, 6 Dec 2007 22:55:54 -0000, "Gunga" <scohen@btinternet.com> wrote: >I have just purchased a PC with Windows Vista already installe...

Create Invoice to Customer before Invoice from Vendor is Received
We need to create Sales Order, then use it to create Purchase Order and transfer Order to Customer Invoice BEFORE we receive invoice from vendor. We are often doing drop shipments, and our drop shipment vendor bills us more slowly than we want to bill our customers. If we create PO from Order, then we cannot transfer Order to Invoice until we match vendor invoice to PO. We cannot afford to wait for Vendor bill - cash flow issues, you know. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggesti...

cell reference changes after macro runs
I have two workbooks with simple identical formulas that update control number after the macro runs. One workbook is ok. The other wil not update the control number. Instead, it changes the cell referenc to one row higher and returns the previous control number. Here's wha each workbook looks like: Sheet one: cell C7 is the control number:20040004.formula for C7 i :=sheet2!'B5+1' Macro: Insert new row 5 on sheet 2,cut data from sheet 1 row 7, past into sheet 2 row 5. After the macro runs, the cell ref. on sheet 1, C7 changes to =B6+1. tried adding $ around $B5$+1, locking cel...

Office 2007
I have Office 2007 installed on an WinXP machine. I've added to my start menu the following short-cuts: New Microsoft Office Document Open Microsoft Office Document I have a few questions, 1. What is the default location of the files listed in the New Microsoft Office Document window? 2. Can I add tabs to the New Microsofot Office Document window? If so, how? 3. What is the default location for the Open Microsoft Office Document window? Assume I've made no changes to the install of Office 2007. Your assistance and help is greatly appreciated! (B^>)-]=[ ...

Count number of shaded cells
I have a number of colour cells in column A. For example: I may have two yellow cells, 3 red cells and 4 blue cells. I would like a formula that can count the number of either the yellow, red or blue cells in a particular column. I would then like to expand this to counting the number of certain colour cell (example ... yellow cells) in a number of columns. i.e columns A to F. Thank you in advance. Hi not possible with formulas alone. This requires VBA. See: http://www.xldynamic.com/source/xld.ColourCounter.html and http://www.cpearson.com/excel/colors.htm -- Regards Frank Kabel Frankf...

Office Macros
What is the latest about when we will be able to upgrade our Office for Mac so that it can run all of our spreadsheets with VB macros? -- "In no part of the constitution is more wisdom to be found, than in the clause which confides the question of war or peace to the legislature, and not to the executive department." - James Madison The only official word from Microsoft is that VBA will return in the next release of Mac Office which is tentatively scheduled for "Holidays 2010" - I take that to mean late 4th quarter of next year. I would not expect to see anything m...

Send Exchange 2003 Out of Office Replies to non Exchange mail serv
Hi, I am new here, so please bear with me. I am hoping someone can help me. I have looked and looked and looked for the answer to my question with no luck. I am wondering if it is possible to setup Exchange 2003 Out of Office replies to respond to a non-Exchange mail server within the same domain without opening up to the internet. The reasoning is to prevent spam programs from detecting legit addresses. Main Mail Server for Staff & Faculty: Exchange 2003 Enterprise Edition Main Mail Server for Students: SurgeMail from NetWinSite.com They are in the same domain, but I am wanti...

Run a Macro after a cell changed due to a calculation
I'm sorry but i posted this already in programming. Yet i noticed the remark that it would be better to post it here. As it isn't the most simple question around. Goodday, I tried to use the worksheet change functions, yet they only seem to act when you actively enter into a certain cell. However i need to call a certain macro when the output in a certain cell changes due to the change in the specific if function. Therefore without user intervention. Is there any way to do this? Kind regards, Ivo Geijsen --- Message posted from http://www.ExcelForum.com/ Take a look at the w...

Lookup cell in table to get entire row
My source table has many rows. One of the columns in this table is "Category". Each row's Category column is one of "A", "B", "C", or "D". I want formulas to generate a second table with all the entire rows of the source table, grouped by category. So first is all the rows with Category A, then all the rows with Category B, etc. There's a clever easy way to do this, right? Thx y'all. Hall, Yeah. Just sort the table on the Category column. Be careful -- do not select just the category column. Either select ONE CELL, or t...

Categories disappeared after upgrade from Office 2k3 to 2k7??
After upgrading from Office 2003 to Office 2007 all of my categories are gone. I still have a complete backup of my system containing Office 2k3 with working categories, is there a way to manually transfer the Categories to Office 2k7? Any help in this area would be completely appreciated. Thx NewsReader2k;115976 Wrote: > After upgrading from Office 2003 to Office 2007 all of my categories > are > gone. > > I still have a complete backup of my system containing Office 2k3 with > working categories, is there a way to manually transfer the Catego...

Creating mailbox with Add User wizward
I created a user and checked the create mailbox option in ADU&C. The user was created, but the mailbox was not. When I checked the mail server the mailbox was not in the information store, but when I checked the Exchange tasks for the user, the create mailbox was not there and delete mailbox was. The system had 8 hours to replicate. Any ideas on what the problem is? I am having a similar problem that seems to have just started. I created a user via the ADU&C wizard answering all questions verifying the creation of an email address in the correct mailbox store. When I close the u...

How do I change the data set on the X axis? (office 2003)
OK, so I created a frequency histogram (bar chart) by selecting the values for the Y-axis, but I can't figure out how to change the values on the X-axis to fit the rest of my values.... When I make the graph using both sets of data, it gives me two separate bar charts on the same plane. Help please :) Thanks Remove the text in the top cell over the x-values; now make the chart. Excel thinks you have two data series best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "jrexattack" <jrexattack@discussions.microsoft.com&...

Opening/importing data from database takes forever after upgrading office!
Hello. I recently reinstalled a users computer and upgraded his office version from 2000 to xp. Now when he imports data from a database it takes forever. It can take several minutes and before the reinstallation the operation only took seconds. What could be wrong? I did the same on his coworkers computer with the same result so there must be something that can solve the problem. I just can't figure it out. The run windows 2000 sp4. Please help. :^) //Johan Anyone? It never hurts to empty the windows temp folder (with excel closed), but it may not help. You may want to take...

office 2003 eula comes up each time you open word,excel
...

creating an index for multiple pages within a visio document?
I have a visio document with about 50 drawings in it. Is there an automated way to create an index from the name of each drawing? Thanks Carol in Roy WA There used to be an add-on "table of contents" but I have not it used in years in earlier versions, but try searching for it. "clemonwa" <clemonwa@discussions.microsoft.com> wrote in message news:B9728AA5-1529-41AC-940C-B275C9D5A1E7@microsoft.com... >I have a visio document with about 50 drawings in it. Is there an >automated > way to create an index from the name of each drawing? > > Thanks &g...

Can I get menus in 2007
Is there any way to get a menu bar w/ word 2007? I like 2007 but the choices in the tabs are not sufficient and I have to fight to get the function I need. thanks john Add what you want to the Quick Access Toolbar. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "John Coltrane" <tendengarci@yahoo.com> wrote in message news:ejbigfJ5KHA.5808@TK2MSFTNGP02.phx.gbl... > Is there any way to get a menu bar w/...

named cells. need a 101
I've been building a 'what if' sheet that pulls in this and that from other sheets. All the sheets have named cells, as does the what if' sheet itself. I want to copy/replicate this sheet multiple times in the wb to allow for multiple and concurrent what if setups. I am worried about named resources (cells) and what's going to happen when I attempt this. I will experiment, but I'm worried about something getting picked up in the wrong place. Is there a good 101 out there that discusses the use of names and what to expect? Thank you. There was an earli...

Re-installation of office
I need to re-install office on my pc after resetting the pc to the original settings. HELP! Insert Office cd, install. Dont have cd? ....explain "Lisa Lucey" <Lisa Lucey@discussions.microsoft.com> wrote in message news:D935368F-BFC7-4C04-96BA-FEAFABC6E358@microsoft.com... >I need to re-install office on my pc after resetting the pc to the original > settings. HELP! ...

create csv which contains unicode
i want to create csv which contains unicode can anyone help me out Requirement is not clear. Use Excel to create the unicode content and then save as CSV or Unicode txt format. "archana" wrote: > i want to create csv which contains unicode > can anyone help me out ...