Auto Backup

russell_piper

Active Member
Joined
Jul 15, 2002
Messages
259
Hey everyone, how ya going ?

Question here, not sure there is an answer.

My friend just called me up and says "been working on excel all day", pc crashed and I have lost all my work", he does not have auto save on.

However does excel store a backup without being told ?

I don't think it does, but maybe some of you super clues will be able to help.

Thanks in advance.

Russ
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Iridium

Well-known Member
Joined
Jul 15, 2002
Messages
2,831
Hello there - ain't seen you for a while!

I think your friend may be ****ed - what version of xl are they using? I've got xl2k2 and there's an autorecover option every x minutes under Tools>Options - Save tab.

Your mate not heard of saving and backing up? The fool!
 

russell_piper

Active Member
Joined
Jul 15, 2002
Messages
259
Yeah I'm not bad, speedy responses as ever on here.

Yeah I think he is screwed also. I have xl xp and I have the same option as you. Under options 13 seperate tabs. He is using 2000 which only has 8 tabs apparently. If he did have autosave on is there a default location where it sends the files to ?

Cheers

Russ
 

Iridium

Well-known Member
Joined
Jul 15, 2002
Messages
2,831
May be worth checking either C:\Documents and Settings\username\Local Settings\Temp or C:\WINDOWS\Temp perhaps?

Edit: on my pc the autorecover info is saved to C:\Documents and Settings\username\Application Data\Microsoft\Excel\ - anything like that in xl2k?
 

russell_piper

Active Member
Joined
Jul 15, 2002
Messages
259

ADVERTISEMENT

Have not got a clue, stuff him, diverted far to much of my time to helping someone who works for 9 hours and does not hit save.

Cheers for the help

On another note I see we both joined this board on the same day.
 

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
Nice to see Iridium's got a friend! :devilish:
If he did have autosave on is there a default location where it sends the files to ?
If he did File-->Save As-->Tools-->General Options-->Always Create Backup at any point in this file's life, then the .xlk backup file will be in the same folder as the original. (But if he didn't save it in the first place he's fubar'd anyway...)

Smitty
 

Iridium

Well-known Member
Joined
Jul 15, 2002
Messages
2,831
russell_piper said:
On another note I see we both joined this board on the same day.

That's spooky!

As for your "mate" I agree with you:
russell_piper said:
stuff him, diverted far to much of my time to helping someone who works for 9 hours and does not hit save

Why bother?

See you around - come back soon!
 

Watch MrExcel Video

Forum statistics

Threads
1,122,798
Messages
5,598,112
Members
414,214
Latest member
marketingnumbersguy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top