Excel file saved data disappears

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Darryl - 31 Mar 2004 18:33 GMT

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.

Reply to this Message

Dave Peterson - 01 Apr 2004 00:59 GMT

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.)

> 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
[quoted text clipped - 12 lines]
>
> Any help is much appreciated.

Signature

Dave Peterson
ec35720@msn.com

Reply to this Message