ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I stop the "Too many different cell formats" ? (https://www.excelbanter.com/excel-worksheet-functions/62622-how-do-i-stop-too-many-different-cell-formats.html)

bebz

How do I stop the "Too many different cell formats" ?
 
I have moved a sheet to another workbook, and now every time I want to do any
formating it gives me an error "Too many different cell formats" ? Whan can I
do to get rid of this?

Dave Peterson

How do I stop the "Too many different cell formats" ?
 
Reduce the number of formats in your workbook.

Some info:

XL: Error Message: Too Many Different Cell Formats
http://support.microsoft.com/default.aspx?scid=213904

If the file gets too bad, excel may not even open it.

If that happens, then 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.

http://www.openoffice.org, a 60-65 meg download or a CD

bebz wrote:

I have moved a sheet to another workbook, and now every time I want to do any
formating it gives me an error "Too many different cell formats" ? Whan can I
do to get rid of this?


--

Dave Peterson


All times are GMT +1. The time now is 02:12 AM.

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