Entries disappear from spreadsheet

[KarenNZ]

I'm running Office 2000 on Windows XT and using an excel spreadsheet to make bookings.

I am fastidious about saving my work but people are calling to say that the service provider has done a no show. When I check for their booking it isn't there.

This has also happened on a different computer.

Any ideas?

 

[GlennUK]

Is this a shared workbook?

Or, are you sure that you are accessing the same version of the workbook every time? ( e.g. are you maybe saving the workbook to an alternate folder sometimes? )

 

[KarenNZ]

Thanks Glenn, no not shared and always saved to the same location, in a folder on the desk top.

It's happening with all of my spreadsheets. Once I close them my saved work is sometimes unsaved.

It seems the problem has been imported from the previous computer where I was experiencing the problem also. I reloaded those spreadsheets from an external drive onto this computer so have plainly brought the problem along too.

All of these spreadsheets have been created using the default new page in excel, then saved under whatever name. No macros or any fancy stuff.

Does that help any?

 

[GlennUK]

No, that is something that I've never come across.

Although numerous times I've had users says that is the case, it always has turned out to be user error, and usually the cause has been saving the data to the wrong place.

I just cannot imagine what is happening in your case ... as you seem confident that it isn't user error. Do you have any files in your XLSTART area? Or a Personal.xls? If either of these have odd macros in, they may be firing up and destroying data.

Does anyone else in your organisation have access to that folder? You may have a careless ( or malicious ) co-worker interfering with your data. Maybe you ought to put a password on your file to prevent unauthorised access.

Is there any chance that old files are being restored from back-up without your knowledge? I don't know how you'd go about checking that. I suppose you could check the date/time stamp last thing before you leave, and then check again in the morning to see if an older date/time stamp exists for the file.

 

[Ruddles]

1) If you add some data and save the workbook, then close it and re-open it immediately, has the added data vanished already?

If so, that would point to something in the save/re-open process going awry.

If not, something is happening to your file after you've confirmed it has been updated and re-opened successfully.

2) Each time you save it, make a note of the date and time. Before you re-open it subsequently, check the date/time on the file first and confirm it's the same as the date/time you saved it.

3) As Glenn says, check there are no macros anywhere which may be destroying your data.

4) Try saving the file to the same location but with a different name and see if that produces a different outcome.

5) Try saving the file to a different location and see if that produces a different outcome.

6) Are you using the same PC each time you update this file? Where is your Desktop? On your C: drive?

7) Are you on a network with roaming profiles? Is your Desktop being reloaded from the server each time you log in?