LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
wheelsii
 
Posts: n/a
Default How do I find out how many different cell formats an existing wor.

I'm having difficulty copying a worksheet into an exisitng workbook, the
error comes back "too many cell formats". I know that Excel allows 4,000
different cell formats, but I can't tell which file needs to be adjusted to
reduce the number of cell formats. Is there a way to find out how many cell
formats are already in use in a particular file?
 
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
How can I know the no of different cell formats in a Excel workbo. Sunil Excel Discussion (Misc queries) 1 January 31st 05 05:23 PM
numeric cell formats David McColloch Excel Discussion (Misc queries) 1 January 8th 05 11:15 PM
Too many cell formats Jonathan Cooper Excel Discussion (Misc queries) 2 December 22nd 04 10:25 PM
Need formule which would find cell (exmp b3) value on another worksheet! please help! StarGazer Excel Worksheet Functions 1 October 28th 04 08:39 AM
Need find cell b3 value on another worksheet! StarGazer Excel Worksheet Functions 1 October 28th 04 07:09 AM


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

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"