Saving Excel Spreadsheet As I Work

[Tomred]

Hello

It's a number of years since I used Excel due to unforeseeable circumstances.

After having a laptop crash and losing some of a spreadsheet I am working on I am seeking help.

I want to be able to save my Excel 2003 spreadsheets as I work.

Can anyone advise of an automated way to perform the save as I work.

At the moment I am constantly paranoid and keep clicking save!

Thanks In Advance

 

[Trevor G]

Look to set the AutoSave to every minute if that is what you require, but eventually it will slow things down..

Tools Menu and AutoSave (I think)

 

[Dannyh1]

Hi,

Try tools autosave

 

[daveburke114]

Hi

I believe by default it saves a 'auto recover' version of your file every ten minutes. This can be changed in the 'excel options' menu (depending on your version it might be in a different place) to save at any set interval. This will enable you to recover your document if the program crashes. When it starts up after a crash it will ask you if you want to recover the file from the 'auto recover'

If you wish to save over the copy you are using as you work and update the file, instead of pressing save, you can press the short-cut CTRL+S

If you are worried about the harddrive failing and losing your file I would suggest using something like Dropbox, its free and you can save up to 2gb. Once you have selected the folder you want to sync, it uploads it to 'the cloud', so if your HDD crashed you could still recover all your folders!

Thats what I do with my (important) work folder anyway

Hope that helps!

 

[Tomred]

Trevor, Danny and Dave

Thanks for the reply's and advice

I did manage to retrieve some of the spreadsheet.
When I reopened Excel I was given the auto recovery option.


I found the Auto Recovery setting under options as explained, thanks.
I've reduced it to 5 minutes for the moment.

Tools / Options / Save Tab.

Dave
Dropbox is a great program, I downloaded it recently to exchange files with a friend.

Yes, that helped!

I'm over the sinking feeling.