Dead Men Walking

dMw Chit Chat => The Beer Bar => Seriously though ... => Topic started by: DuVeL on March 24, 2006, 10:17:18 AM

Title: Excel help
Post by: DuVeL on March 24, 2006, 10:17:18 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.
Title: Excel help
Post by: delanvital on March 24, 2006, 10:55:55 AM
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.
Title: Excel help
Post by: Gandalf on March 24, 2006, 10:56:12 AM
QuoteOriginally 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 :P

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.
Title: Excel help
Post by: DuVeL on March 24, 2006, 11:11:44 AM
QuoteOriginally posted by Gandalf-LordOfJelly@Mar 24 2006, 12:56 PM
It never used to be on the older versions of excel :P
[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...
Title: Excel help
Post by: suicidal_monkey on March 24, 2006, 12:22:10 PM
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
Title: Excel help
Post by: A Twig on March 24, 2006, 12:36:52 PM
Saving is for girls. Real men just type fast and try to hit print before the crash...
Title: Excel help
Post by: delanvital on March 24, 2006, 02:51:33 PM
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?
Title: Excel help
Post by: DuVeL on March 24, 2006, 03:17:15 PM
QuoteOriginally 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).
Title: Excel help
Post by: A Twig on March 24, 2006, 07:17:13 PM
QuoteOriginally 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...  ;)
Title: Excel help
Post by: scot on March 24, 2006, 07:59:26 PM
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