View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Paul Gauci Paul Gauci is offline
external usenet poster
 
Posts: 13
Default How do I deal with a "Too many different cell formats".

Thanks Dave

Actually some time ago I experienced a corruption of a Word file which
contained a large multi-page table and I managed to solve the problem by
following the Open Office procedure. I tried it out as a last resort after
the save-to-web page approach
failed.

I shall try this procedure out with my excel file and post the result.


Paul
--
Paul Gauci


"Dave Peterson" wrote:

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

Paul Gauci wrote:

Further to my question.
I am trying to remove some formatting (am avoiding the Edit-Clear-Format
command for the moment as this will require me to carry out a major
reformatting of over 60 worksheets), but I am not being permitted to undo
such formats. I basiccally need to avoid redoing most of my work.
--
Paul Gauci

"Paul Gauci" wrote:

I keep getting the message "Too many different cell formats" which is
prfeventing me from completing my current assignment. The file that I am
working on has grown to about 4MB.

Is there a way in which I can go around thgis probelm?


--
Paul Gauci


--

Dave Peterson