Excel help

[DuVeL]

I know that excel automaticly saves the files once in a while. My boss did some work this morning but then his computer auto-restarted (happens to him from time to time).
Where can I find the settings for the Autosave so I can find the hopefully backed up file.

[delanvital]

Settings -> Save (I guess, mine is danish)

For instance my path shown there is

C:\Documents and Settings\Administrator\Application Data\Microsoft\Excel\

NB. Same place you set the time interval.

[Gandalf]

Originally posted by DuVeL@Mar 24 2006, 10:17 AM
I know that excel automaticly saves the files once in a while. My boss did some work this morning but then his computer auto-restarted (happens to him from time to time).
Where can I find the settings for the Autosave so I can find the hopefully backed up file.

[post=119053]Quoted post[/post]

[/b]

I think it only does that if you turn it on. And I believe that the auto save just saves the document in its original location. EDIT: It looks like it's turned on by default now, delanvital has posted the location. It never used to be on the older versions of excel

If it's a recovered file then opening excel should list all of the recovered files on the open window frame, however I think it only does this if excel crashes.

[DuVeL]

Originally posted by Gandalf-LordOfJelly@Mar 24 2006, 12:56 PM
It never used to be on the older versions of excel

[post=119069]Quoted post[/post]

[/b]

We 're using Microsoft Office 2000 SR-1 Professional but it seems that we can't even automaticly save so there for we wern't able to find the file. Thanks guys...

[suicidal_monkey]

dunno if it'll help but there's a
start-->programs-->Microsoft Office Tools-->Microsoft Office Application Recovery
no idea what it does though!

I set them all to auto save about every 5 minutes, though even repairing the last 5 minutes of changes can be a right pain

[A Twig]

Saving is for girls. Real men just type fast and try to hit print before the crash...

[delanvital]

I remember Office '97 having auto save. I believe you should have the function in your version. And as far as I can remember, it is on by default. Did your version note have a "save" section in settings?

[DuVeL]

Originally posted by A Twig@Mar 24 2006, 02:36 PM
Saving is for girls. Real men just type fast and try to hit print before the crash...

[post=119100]Quoted post[/post]

[/b]

Real men don't have hatched eggs in their sigs.

When I want to "save"there is an option "Extra" with several options but this just makes a bacckup copy (not to usefull).

[A Twig]

Originally posted by DuVeL@Mar 24 2006, 03:17 PM
Real men don't have hatched eggs in their sigs.

[post=119133]Quoted post[/post]

[/b]

But JB does in his signature and...

Oh wait, ok point taken...  

[scot]

go to  Tools .... choose options... and on there is a save tab where you can configure the auto save for time interval and location. It will tell you there where it has been saving the file and u can change to suit
HtH