Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    May 2001
    Location
    Omaha, NE USA, Nebraska, USA
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    File error: Some data may have been lost (Excel 97/SR2)

    A co-worker and I have been experiencing similar problems to some of the Excel files that we use on a daily basis.

    When opening the file, a dialog box appears reading "File Error: Some data may have been lost", with only an OK button. When you press the OK button, the file continues to open. The issues becomes that at least one of the worksheets within the workbook has corrupted formulas. At a random cell within the worksheet the entire formula is replaced with #!REF.

    We have found that the only way to resolve this is to re-create the worksheet and then delete the worksheet with the bad references. Very annoying and time consuming, not to mention the potential to lose mission critical data.

    Has anybody seen/experience this before? Any ideas on prevention or resolution? We are both running Windows NT4.0 SP6 and Office 97 (Excel97/SR2). My machine has 128K RAM and my co-worker is running 256K.

    <img src=/S/help.gif border=0 alt=help width=23 height=15>

  2. #2
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Quakertown, PA, Pennsylvania, USA
    Posts
    517
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File error: Some data may have been lost (Excel 97/SR2)

    Maybe you've been there, but I'll post anyway, Steve:

    E97 & IE4

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: File error: Some data may have been lost (Excel 97/SR2)

    SOunds like a workbook corruption indeed. In my experience, the only way around those is recreating the workbook/sheet containing the corruption.
    You could try saving the book to HTML format and reloading it. It sometimes helps resolving things like this.
    Another thing to do is start using my (greatly enhanced) autosave utility called Autosafe.zip. Find it at:

    http://www.bmsltd.ie/mvp

    Edited Mar 13th 2004 to update link
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •