ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Getting "Too many different cell formats" error - utility or metho (https://www.excelbanter.com/excel-discussion-misc-queries/46056-getting-%22too-many-different-cell-formats%22-error-utility-metho.html)

SharonP.

Getting "Too many different cell formats" error - utility or metho
 
Hi, I have a larger spreadsheet and am getting the "too many different cell
formats used" error. Is there a utility or method to use to go about first
off 1. identifying
how many cell formats are used? 2. identifying occurances that that unique
or minimal so I can change then to a normal style?

Bob Phillips

See
http://support.microsoft.com/default.aspx?kbid=213904
You receive a "Too many different cell formats" error message in Excel

--
HTH

Bob Phillips

"SharonP." wrote in message
...
Hi, I have a larger spreadsheet and am getting the "too many different

cell
formats used" error. Is there a utility or method to use to go about

first
off 1. identifying
how many cell formats are used? 2. identifying occurances that that

unique
or minimal so I can change then to a normal style?





All times are GMT +1. The time now is 08:46 PM.

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