Similar question previously answered by Dave McRitchie
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.
