Lost files / data

[Geoff]

I am using Excel 2003 on MSXP. I have a file for tax records opening a new
worksheet for each new tax period. I input data over two days on a new
worksheet no problems. I have auto save every 10 minutes activated. A few
days later I cannot find the data - completely gone and file suggests last
entry was six months ago which was last tax period. Application recovery and
system restore both unsuccessful. Did a test input yesterday and this also
lost overnight. Any ideas?
I wonder if Seagate Free Agent back up system installed previous week has
any link to the problem.

 

[Gord Dibben]

Geoff

Excel 2003 has no Auto Save. The Tools>Options>Save is a misnomer, although it
does mention "Save AutoRecovery info every xx minutes"

It has Auto Recovery which saves a temporary file every 10 minutes, but deletes
that file when you save and close out the original.

The AR file is only good if Excel crashes while you are working on a file.

Are you sure you are saving the file when you are finished working on it at end
of day?

Are you sure you are opening the correct version of the file?

Could be you have two same-named files in separate folders.


Gord Dibben MS Excel MVP

 

[Geoff]

Thanks Gord,
If the auto save doesn't function it seems the data was not deliberately
saved before signing off. If so does that mean the data is lost for good? I
dont think the taxman will be pleased!
Geoff

 

[Gord Dibben]

If no one hit the Save button or responded to the "Do you want to save changes"
message then the data is gone.


Gord