Re: Opening Excel 2002 file in Excel 2000 problems



Each version of excel seems to be sensitive to different levels of corruption.
Usually, the newer versions can handle it better than the earlier version--but
not always.

You may want to try rebuilding the workbook to see if that helps.

If things get really bad...

Lots of people have praised OpenOffice.org for saving their data and code.

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

There are commercial recovery services. I've never used it, but you might want
to check into:
http://www.officerecovery.com

Mark Christensen wrote:
>
> Hello,
>
> I created a worksheet in Excel 2002 SP3. Nothing fancy, just columns and
> rows with text and numbers. When I open it in Excel 2000, the following
> warning box appears:
>
> File error. Some number formats may have been lost.
>
> It doesn't prevent me from opening the file in 2000, but I still don't want
> users to get that message when they open it. I tried saving it as an Excel
> 2000 file but still got the same error when opening it in Excel 2000. I get
> no warnings when I open it in Excel 2002.
>
> Can anyone help? Thanks.
>
> Mark

--

Dave Peterson
.



Relevant Pages

  • Re: Field Data to Microsoft Word.
    ... up with that warning about sql entering the fields. ... unfortunatly i have not done much word automation. ... mailmerge in word to use the excel. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Field Data to Microsoft Word.
    ... putting it into fields in word but it still pops up with that warning about ... maybe I can use automation to answer it yes. ... in word to use the excel. ... Is there another way to set up a doc file with fields that I can ...
    (microsoft.public.fox.programmer.exchange)
  • Re: File Error: Data May Have Been Lost
    ... for several weeks an still get "File error: data may have been lost" error ... when opening some Excel files. ... I've had to keep both Excel 2004 an 2008 on ...
    (microsoft.public.mac.office.excel)
  • Excel shutting down
    ... having an issue with Excel 2007 closing ... abruptly after warning to close some files before opening another. ...
    (microsoft.public.excel.crashesgpfs)
  • Re: Disable column only sorting in Excel
    ... who think excel is a database and send us lots of datafiles in excel format. ... In Excel 2007 there is a popup but not a clear specific warning. ... Expand the selection or Continue with the current selection." ... of their personnel did the type of sort described above. ...
    (microsoft.public.excel.setup)