Lost files / data
Geoff
Excel 2003 has no Auto Save. The ToolsOptionsSave 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
On Sun, 18 May 2008 15:15:00 -0700, Geoff
wrote:
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.
|