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?

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 .


"JJGPBG" wrote:

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?

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

On Wed, 7 Mar 2007 13:59:25 -0800, JJGPBG
wrote:

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?