LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default "too many different cell formats". How to solve this problem?

Please HELP!!

A very simple Excel table of figures and formulas, although large (~300 L x
~10 000 C x 10 WSheets, ~20Mb), is giving this stupid error

"too many different cell formats"


and, in the sequence, doesn't let me proceed! Not even changing one single
cell format!!
Curiously, though, it doesn't happen in other similar files, with longer
number of lines (~1000 L x ~10 000 C x 8 WSheets, 20 to 30Mb)

Why this and how can solve it or, at least, turn around it? It's getting me
crazy!

I have a MS Excel 2003, SP3, in MS Prof Edition 2003.

Thank youy in advance for your "urgent" help.
Eduardo Oliveira

Lisbon, Portugal
 
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
Best way to trap error to MsgBox "Too many cell formats" [email protected] Excel Discussion (Misc queries) 0 August 22nd 06 09:52 PM
what is the problem" TOO MANY DIFFERENT CELL FORMATS"? Alireza Excel Worksheet Functions 1 August 19th 06 01:22 PM
what is the problem" TOO MANY DIFFERENT CELL FORMATS"? Alireza Excel Discussion (Misc queries) 1 August 19th 06 01:22 PM
any solution to the "too many cell formats error" in excel? Mini Excel Discussion (Misc queries) 1 May 31st 06 11:45 AM
How do I solve "too many different cell formats" in Excel 2003 Brettjg Excel Discussion (Misc queries) 1 December 12th 05 03:13 PM


All times are GMT +1. The time now is 12:05 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"