J
JoeZ
With Word, I can to Options/Advanced/Save and choose to Always create backup
copy. Then, every time I resave a Word 2007 doc, I get the backup with a
..wbk file extension.
I just can't figure out how to do the same with Excel.
There is no comparable Options/Advanced/Save choices. I do see in Word the
AutoRecover option in Options/Save- though there is something weird about
that because it has for a default AutoRecover file location:
C:\Users\Joseph\AppData\Roaming\Microsoft\Excel\ but I can't find the
AppData folder unless it's hidden.
In the Excel help file- it has a description of how to "Automatically save a
backup copy of a workbook" but instead of describing how to do that- it
describes the AutoRecover feature. But, that's not what I want- I want to
see the actual backup file get created each time I resave an Excel file-
just like those Word .wbk files.
I'm obviously doing something stupid.
Joe
copy. Then, every time I resave a Word 2007 doc, I get the backup with a
..wbk file extension.
I just can't figure out how to do the same with Excel.
There is no comparable Options/Advanced/Save choices. I do see in Word the
AutoRecover option in Options/Save- though there is something weird about
that because it has for a default AutoRecover file location:
C:\Users\Joseph\AppData\Roaming\Microsoft\Excel\ but I can't find the
AppData folder unless it's hidden.
In the Excel help file- it has a description of how to "Automatically save a
backup copy of a workbook" but instead of describing how to do that- it
describes the AutoRecover feature. But, that's not what I want- I want to
see the actual backup file get created each time I resave an Excel file-
just like those Word .wbk files.
I'm obviously doing something stupid.
Joe