Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Excel Errors / January 2005

Tip: Looking for answers? Try searching our database.

EXCEL Format problems between XP and Win2000/2002/2003

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
PlsHelp - 27 Jan 2005 14:01 GMT
File formats of an EXCEL file created in XP will get
altered when the file is brought up in Win2000/2002/2003.  
For large EXCEL files created/updated in XP will cause
problem when formatting cells of the file in
Win2000/2002/2003....Error message "too many different
cell format".  This is a major show stopper when files
cannot be shared properly between Windows OS.  Meanwhile,
what to do?
Ken Wright - 27 Jan 2005 22:55 GMT
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%40tkmsftngp02

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" <nusi@szm.sk> wrote ...
> How can I open an Excel file without any format loss,
> please? I've got Windows XP Pro, Office 2k, AMD
[quoted text clipped - 4 lines]
> step-by-step instructions how to open it without any data-
> loss and also without any other-programm instalations.

Signature

Regards
          Ken.......................    Microsoft MVP - Excel
             Sys Spec - Win XP Pro /  XL 97/00/02/03

----------------------------------------------------------------------------
                 It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

> File formats of an EXCEL file created in XP will get
> altered when the file is brought up in Win2000/2002/2003.
[quoted text clipped - 4 lines]
> cannot be shared properly between Windows OS.  Meanwhile,
> what to do?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.