Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formating cells - "Too Many Different Cell Formats" Error | Excel Discussion (Misc queries) | |||
Excel Error :- "Too Many Cell Formats"...is there a way of finding | Excel Discussion (Misc queries) | |||
Best way to trap error to MsgBox "Too many cell formats" | Excel Discussion (Misc queries) | |||
How to override "Too Many Cell Formats" error comment. | New Users to Excel | |||
any solution to the "too many cell formats error" in excel? | Excel Discussion (Misc queries) |