Too many different cell formats.

  • Thread starter Thread starter Thomas
  • Start date Start date
T

Thomas

Is it possible to open an Excel spreadsheet that only
displays the message: "Too many different cell formats" ?
 
Thomas,

I have never seen it. My guess is NO. But I am not positive.

Regards,
Kevin
 
Previous post from Dave McRitchie in response to a similar question:-

Hi Stefan,
Formatting is not going to result in data loss.
Formatting is the presentation display.

You have to run a macro, I don't think you really want to
delete formats one at a time manually.

You will have to pick out some formats to delete in order
to open your file, you should be able to spot 4 that you
do not need. The limitation of format is the combination
of font format attributes, number format, border(s) format

Cutting down on excessive formatting would help.
It is best to format an entire page, column etc, than
one cell at a time.

the following was Extracted from
http://www.mvps.org/dmcritchie/excel/slowresp.htm#formats

Leo Heuser posted a macro 2001-05-06 in programming as a very
major revision of the macro in the eee007 article.
http://google.com/groups?selm=OxP9cgi1AHA.1572@tkmsftngp02

As far as important data, or any other user files.
You should always have a backup of your files.
http://www.mvps.org/dmcritchie/excel/backup.htm
---
If you've never installed a macro before see getstarted.htm
on my pages.
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Stefan Kralovic said:
How can I open an Excel file without any format loss,
please? I've got Windows XP Pro, Office 2k, AMD
Thunderbird 1200, 512MB RAM and so on. In my opinion,
this error message isn't caused by performance of my
computer. This document contains too important data for me
and it took a long time for me to create it. Please send me a
step-by-step instructions how to open it without any data-
loss and also without any other-programm instalations.
Click to expand...
 
Would you happen to know of any utilities for Excel
spreadsheets that seem impossible to open?
 
Take a look at my post. The other option is to try using OpenOffice which is a free
download from www.openoffice.org approx 60MB and is very good at opening Excel files that
Excel cannot open.
 
Thomas,

In addition to Ken's excellent advice, you can also try the following
approach. (Be sure to back up your file before attempting the suggestion
below.)

Rename the file to an htm file. For example, if you had MyTest.xls rename
it to MyTest.htm. Then open the HTM file in Excel. I have used this
approach when I have had corrupted files.

Best regards,
Kevin
 
Back
Top