"Back of...." files help

[ddub25]

In the main folder where I save my Excel files I have backup files which are automatically generated. These are labelled "Backup of..." followed by the name of the orginal file.

Can anyone tell me why these are being generated? Is it an Excel setting or possibly a Microsoft Office setting (I can't see anything in the Excel Options settings that should be creating Backups)?

I don't mind having backups but they would be more useful if I could have them backed up to a different location on a different drive maybe. Any ideas.

Dan

 

[Smitty]

Try File-->Save As-->Tools-->General Options-->Uncheck "Always create backup".

HTH,

 

[ddub25]

I have Excel 2007 and can't find these links. Instead of 'File' I have an 'Office' button/Save As/Excel Options... and then nothing for Uncheck "Always create backup.

 

[wigi]

In the explanation of Smitty, the only thing you needed to change was that File becomes the Office button.

See:

http://grok.lsu.edu/article.aspx?articleid=3174

 

[ddub25]

Thanks, very much, very helpful.

Dan

 

[ddub25]

How can I have these backup files automatically save to a different location? The link sent in the last post tells me how to do this, but when I change the default file location in Excel Options, my backup files still save in the same folder as the file itself.

Dan

 

[ddub25]

I've just noticed as well that I have other files saved in different folders that also backup to their respective folders and not to the 'default file location' selected.

Dan

 

[wigi]

IMO, this is something else. Backups will be stored in the respective folders, while this standard folder is used when you open or attempt to save a file using the UI. Excel will then show you that folder.

To test, hit Ctrl-N to start a new file, and hit F12 to do a SaveAs. Where do you end up?

I could be wrong though.

 

[ddub25]

Just tried it and when I do save as it defaults to my usual location for saving files, not the 'default file location' specified.

So it not possible to have Excel create a backup of a file that would be saved in a completely different location? Seems a bit strange if not because surely the main use for a backup is to have a seperate copy on a different drive if one drive fails. It's not much use to me in the same folder and also quite irritating clogging up my folder with duplicate backups.

Dan

 

[ddub25]

One other related question. I've set the 'AutoRecover File Location' to a different location other than the default (as this is a hidden folder), and set it to 'Save AutoRecover information' every 10 minutes.

I set this last night, but have not received any saves into this folder at all. What should be saved into this folder every 10 mins?

Is there a problem with the extention (C:\Users\Dan\Dropbox\WFH\IT\Excel Auto Recover) maybe?. Does folders have to be named without spaces?

Dan