Excel file saved data disappears

  • Thread starter Thread starter Darryl
  • Start date Start date
D

Darryl

I have some users who are having a problem with Excel files reverting
back to old data. It does not happen all of time but quite often
recently when they make changes, save them (with no errors and to the
original file name/location), and then reopen the file, the changes
are gone.

This is not a case of the users saving to a different location and
looking at the wrong file. They recieve no error messages when saving
or opening.

Any ideas as to what is happening?

It is Excel 2000 running on Windows 2000 clients with the files being
saved on a Windows 2000 server.

Any help is much appreciated.
 
I've never seen excel/windows screw up like this.

But I know that I have saved to a different location and reopened the wrong one.

Maybe you could add a worksheet formula in a cell in the worksheet so you can
see what's been opened.

=CELL("filename",A1)

You could put the "real" location in an adjacent cell and a formula that
compares them:

=if(a1=a2,"","NOT THE CORRECT LOCATION!"

Make it bold and red to get their attention.

(Or you could just ask them what they see as a result of that formula.)
 
Back
Top