ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I resolve "too many different cell formats" error? (https://www.excelbanter.com/excel-discussion-misc-queries/191688-how-do-i-resolve-too-many-different-cell-formats-error.html)

Seema

How do I resolve "too many different cell formats" error?
 
I have an old Excel file that has moved several Excel versions. Now, I am
unable to alter the formatting in any cell. I am getting the following error
message - "too many different cell formats".

I have tried removing all formatting, removing the formatting for one cell,
copying the spreadsheet and everything else I could think of but nothing
works.

Please help this is a very important financial spreadsheet.

Thanks
Seema

Jim Rech

How do I resolve "too many different cell formats" error?
 
There is no magic solution. You must 'simplify' the formatting.

http://support.microsoft.com/kb/213904

--
Jim
"Seema" wrote in message
...
|I have an old Excel file that has moved several Excel versions. Now, I am
| unable to alter the formatting in any cell. I am getting the following
error
| message - "too many different cell formats".
|
| I have tried removing all formatting, removing the formatting for one
cell,
| copying the spreadsheet and everything else I could think of but nothing
| works.
|
| Please help this is a very important financial spreadsheet.
|
| Thanks
| Seema




All times are GMT +1. The time now is 07:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com