autosave save all open worksheets

J

JJGPBG

Does autosave save all open worksheet or only worksheet i am working on at
time of save? If not, is there a way to have all open worksheets on autosave?
 
S

Sara Sun

Autosave, saves all worksheets in a workbook.

When exiting if you hit only yes - it saves all all worksheets in a workbook.
if you hit 'yes to all' - it saves all worksheets in all open workbooks .
 
G

Gord Dibben

What version of Excel are you using and what do you mean by "autosave"?

Versions 2002 and newer do not have an autosave feature, only an autorecivery
feature that saves a temporary file while a workbook is open but deletes that
temporary file as soon as you have closed the workbook.

Not a true autosave which saves incremental backups of your work.


Gord Dibben MS Excel MVP
 
Top