Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
A W A W is offline
external usenet poster
 
Posts: 1
Default Have error condition "Too Many Different Cell Formats"

Have multi-tab Spreadsheet with much cutting and inserting of rows for
updates. Each tab is period in time with lots of formatting and graphs.

To 'simplify', I copied and Paste Special (values) entire worksheet onto
itsself to remove formulas and 'simplify' the entire workbook. Saved and
re-opened the file. Still got the error.

I have EXCEL Professional , Windows Office suite 2003.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default Have error condition "Too Many Different Cell Formats"

Well, you have, as Excel is trying to tell you, too many different formats.
You need to reduce the different formats you are using. Click on the
intersection between rows and columns (or CTRL-A twice) to select all cells
in the sheet, then click on Arial (for example) with 10 pt - all cells will
take on this setting. You can change other font attributes at the same time,
such as bold, italic etc (to get rid of them).

Repeat this for the other sheets.

Hope this helps.

Pete

"A W" <A wrote in message
...
Have multi-tab Spreadsheet with much cutting and inserting of rows for
updates. Each tab is period in time with lots of formatting and graphs.

To 'simplify', I copied and Paste Special (values) entire worksheet onto
itsself to remove formulas and 'simplify' the entire workbook. Saved and
re-opened the file. Still got the error.

I have EXCEL Professional , Windows Office suite 2003.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formating cells - "Too Many Different Cell Formats" Error Krisml Excel Discussion (Misc queries) 3 November 18th 09 08:56 PM
Excel Error :- "Too Many Cell Formats"...is there a way of finding FoS605 Excel Discussion (Misc queries) 4 June 30th 08 03:23 PM
Best way to trap error to MsgBox "Too many cell formats" [email protected] Excel Discussion (Misc queries) 0 August 22nd 06 09:52 PM
How to override "Too Many Cell Formats" error comment. Delg New Users to Excel 3 August 8th 06 06:51 PM
any solution to the "too many cell formats error" in excel? Mini Excel Discussion (Misc queries) 1 May 31st 06 11:45 AM


All times are GMT +1. The time now is 02:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"