#1   Report Post  
Amjad
 
Posts: n/a
Default Format Problem

I have an excel workbook having 37 sheets full of formulas.Size of the file
is about 7mb. Now I am unable to format anything on anysheet and getting a
message "Too many different cell format"?

Please someone help me.
  #2   Report Post  
Norman Jones
 
Posts: n/a
Default

Hi Amjad,

See MS Knowledge Base article # 213904:

'You receive a "Too many different cell formats" error message in Excel'

http://support.microsoft.com/default...5BLN%5D;213904


See also a DeleteUnusedCustomNumberFormats procedure wtitten and posted by
Leo Heuser:

http://tinyurl.com/8rhoq

..(See particularly post # 12 in the above NG thread)



---
Regards,
Norman



"Amjad" wrote in message
...
I have an excel workbook having 37 sheets full of formulas.Size of the file
is about 7mb. Now I am unable to format anything on anysheet and getting a
message "Too many different cell format"?

Please someone help me.



Reply
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
OsCommerce - Easy Populate Script - CSV/TXT Conversion Problem. PriceTrim Excel Discussion (Misc queries) 3 July 5th 05 05:27 PM
Copy cell format to cell on another worksht and update automatical kevinm Excel Worksheet Functions 21 May 19th 05 11:07 AM
date format problem Nigel Excel Discussion (Misc queries) 7 May 11th 05 12:57 PM
Conditonal Format with a date format Kevin Excel Discussion (Misc queries) 2 April 27th 05 10:20 PM
Problem with txt format Nuno Excel Discussion (Misc queries) 1 January 18th 05 04:11 PM


All times are GMT +1. The time now is 10:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"