How do I automatically save a backup copy of Excel 2007 spreadshee

S

swong74

In Excel 2003 and before that, I was able to setup a worksheet to auto save a
previous version as "Backup of <filename>" and although my previous XLS file
does that in Excel 2007, I'm unable to configure it for new XLS I've created.
Where is it setup? Thanks.
 
R

Ron de Bruin

Hi swong74

Office Button>File>SaveAs
See the Tools dropdown next to the Save button in this dialog
 
Top