E
Elsie
hi, have a pc running xp with office 97. sometimes, excel hangs and all data
is gone. how can I retrieve my data?
Elsie
is gone. how can I retrieve my data?
Elsie
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Kevin H. Stecyk
Elsie,
Try cleaning out your Temp folder.
It is likely located somewhere like this:
C:\Documents and Settings\YourName\Local Settings\Temp
Good luck.
Kevin
Try cleaning out your Temp folder.
It is likely located somewhere like this:
C:\Documents and Settings\YourName\Local Settings\Temp
Good luck.
Kevin
E
Elsie
ok, so next time a excel file hands, I just go check out that folder?
K
Kevin H. Stecyk
Elsie,
Yeah, that folder should be cleaned out periodically.
To be honest, I don't understand all the nuts and bolts, but I know that it
clutters up Excel. I tend to clean it out weekly or more frequently. You
might even want to assign a shortcut on your desktop to that folder to be
able to clean it out easily.
It clutters other programs as well.
Best regards,
Kevin
Yeah, that folder should be cleaned out periodically.
To be honest, I don't understand all the nuts and bolts, but I know that it
clutters up Excel. I tend to clean it out weekly or more frequently. You
might even want to assign a shortcut on your desktop to that folder to be
able to clean it out easily.
It clutters other programs as well.
Best regards,
Kevin
D
Dave Peterson
I'd clean it up right away. (I clean mine every day!)
If you wait for xl to crash, it won't be too useful for you that time.
But if you clean it up and xl doesn't crash, you may have found the fix.
A quick way to get to the temp folder:
windows start button|Run
%temp%
I close all running programs (right after I turn it on or right before I turn it
off) and delete everything in there. (Don't be installing/deinstalling anything
when you do this.)
If you wait for xl to crash, it won't be too useful for you that time.
But if you clean it up and xl doesn't crash, you may have found the fix.
A quick way to get to the temp folder:
windows start button|Run
%temp%
I close all running programs (right after I turn it on or right before I turn it
off) and delete everything in there. (Don't be installing/deinstalling anything
when you do this.)
E
Elsie
ok... but how can I retrieve my data?
cos it seems that the temp folder just need to be cleaned up in the previous
posts.
Elsie
cos it seems that the temp folder just need to be cleaned up in the previous
posts.
Elsie
T
Trevor
If you have Auto-Save turned on (it is turned on by default, so if you're
not sure, then it's on) then Excel will periodically save a copy of your
data for you. If everythign freezes up and you must reboot, look for a file
with an odd name, like ~8791414.xls. This has a copy of your data at the
time Excel did it's last automatic save. Note that auto-saves occur every
10 minutes, by default. You can find this file in your working directory,
or in that very same temp directory. The file name always starts with a ~
and ends with .xls. I can't remember if they are also hidden, so if you're
having trouble finding the file, keep that in mind.
not sure, then it's on) then Excel will periodically save a copy of your
data for you. If everythign freezes up and you must reboot, look for a file
with an odd name, like ~8791414.xls. This has a copy of your data at the
time Excel did it's last automatic save. Note that auto-saves occur every
10 minutes, by default. You can find this file in your working directory,
or in that very same temp directory. The file name always starts with a ~
and ends with .xls. I can't remember if they are also hidden, so if you're
having trouble finding the file, keep that in mind.
Elsie said:ok... but how can I retrieve my data?
cos it seems that the temp folder just need to be cleaned up in the previous
posts.
Elsie
andDave Peterson said:I'd clean it up right away. (I clean mine every day!)
If you wait for xl to crash, it won't be too useful for you that time.
But if you clean it up and xl doesn't crash, you may have found the fix.
A quick way to get to the temp folder:
windows start button|Run
%temp%
I close all running programs (right after I turn it on or right before I turn it
off) and delete everything in there. (Don't be installing/deinstalling anything
when you do this.)
G
Gord Dibben
Trevor
This is Excel 97 OP is talking about.
AUTOSAVE.XLA is an add-in and must be loaded by user from Tools>Add-ins. It
is not on by default.
Autosave overwrites the file at intervals set by the user. It does not save
copies for recovery as you suggest.
The Auto Recovery feature, which I believe you are thinking of, was introduced
in Excel 2000.
Auto Recovery files are *.XAR and you would most likely find them in
C:\Documents and Settings\User\Application Data\Microsoft\Excel
Gord Dibben Excel MVP
This is Excel 97 OP is talking about.
AUTOSAVE.XLA is an add-in and must be loaded by user from Tools>Add-ins. It
is not on by default.
Autosave overwrites the file at intervals set by the user. It does not save
copies for recovery as you suggest.
The Auto Recovery feature, which I believe you are thinking of, was introduced
in Excel 2000.
Auto Recovery files are *.XAR and you would most likely find them in
C:\Documents and Settings\User\Application Data\Microsoft\Excel
Gord Dibben Excel MVP
If you have Auto-Save turned on (it is turned on by default, so if you're
not sure, then it's on) then Excel will periodically save a copy of your
data for you. If everythign freezes up and you must reboot, look for a file
with an odd name, like ~8791414.xls. This has a copy of your data at the
time Excel did it's last automatic save. Note that auto-saves occur every
10 minutes, by default. You can find this file in your working directory,
or in that very same temp directory. The file name always starts with a ~
and ends with .xls. I can't remember if they are also hidden, so if you're
having trouble finding the file, keep that in mind.
T
Trevor
didn't know that the autorecovery was so "new" thanks for the great
insight, Gord.
insight, Gord.
D
Dave Peterson
This may provide help if/when xl crashes in the future: Jan Karel Pieterse has
an addin that's very nice.
It called AutoSafe (note spelling)
It doesn't overwrite the existing workbook when it saves. It saves to a user
selectable folder. And when it's done, it either deletes these backups (or puts
them in the recycle bin). And the user can always restore the backups from the
recycle bin.
http://www.jkp-ads.com/Download.htm
(look for AutoSafe.zip, not autosafeVBE.zip, for your purposes.)
an addin that's very nice.
It called AutoSafe (note spelling)
It doesn't overwrite the existing workbook when it saves. It saves to a user
selectable folder. And when it's done, it either deletes these backups (or puts
them in the recycle bin). And the user can always restore the backups from the
recycle bin.
http://www.jkp-ads.com/Download.htm
(look for AutoSafe.zip, not autosafeVBE.zip, for your purposes.)