Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Error Code: "Too many different cell formats"

I have a somewhat large, multi-page workbook that consistently gives me the
above error code and does not allow me to make change or enter additional
formulas. Anybody know anything about this?

THX!
Katz
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 347
Default Error Code: "Too many different cell formats"

Hi,

Try opening the file while excel runs in safe mode, then remove some of the
formats:

Start/Run: excel.exe /s

HTH
Jean-Guy

"Katz" wrote:

I have a somewhat large, multi-page workbook that consistently gives me the
above error code and does not allow me to make change or enter additional
formulas. Anybody know anything about this?

THX!
Katz

  #3   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
 
Posts: 1,397
Default Error Code: "Too many different cell formats"

http://support.microsoft.com/default.aspx?scid=213904
gives a defensive description

"Katz" wrote:

I have a somewhat large, multi-page workbook that consistently gives me the
above error code and does not allow me to make change or enter additional
formulas. Anybody know anything about this?

THX!
Katz

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Error Code: "Too many different cell formats"

Maybe...

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

A few people have said that OpenOffice.Org has been able to open the file. Then
they clean it up and save it there. Then excel can open that cleaned up
version.

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

Katz wrote:

I have a somewhat large, multi-page workbook that consistently gives me the
above error code and does not allow me to make change or enter additional
formulas. Anybody know anything about this?

THX!
Katz


--

Dave Peterson
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
Error: "Too many different cell formats" extremme Excel Discussion (Misc queries) 5 August 2nd 06 08:15 AM
I'm getting a "Too many cell formats" error. Victoria_in_NY Excel Discussion (Misc queries) 2 January 27th 06 08:52 PM
Error: "too many different cell formats" Vlookup help Excel Discussion (Misc queries) 3 January 5th 06 02:49 PM
How do I stop the "Too many different cell formats" ? bebz Excel Worksheet Functions 1 January 1st 06 03:24 PM
cell color index comparison MINAL ZUNKE New Users to Excel 1 June 30th 05 07:11 AM


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

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"