| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving Workbooks
Hi,
I want to save all my opened workbooks once without having to be saving and closing each workbook individually. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Saving Workbooks
Try this, hold down Shift key, then File, Close all. You will still have
to click Yes to save changes. Jamad wrote: Hi, I want to save all my opened workbooks once without having to be saving and closing each workbook individually. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Saving Workbooks
While holding down a shift key, click FILE in the menu and select CLOSE ALL..
If you've made any changes to a workbook a dialog box appears asking if you want to save the changes made to "Workbookname". Click the YES TO ALL command button and all modified workbooks will be saved and closed automatically. -- Kevin Backmann "Jamad" wrote: Hi, I want to save all my opened workbooks once without having to be saving and closing each workbook individually. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving the Macro for all workbooks | New Users to Excel | |||
| Saving multiple Workbooks | Excel Discussion (Misc queries) | |||
| Saving Workbooks w/ Charts | Excel Discussion (Misc queries) | |||
| Shared Workbooks Saving | Excel Discussion (Misc queries) | |||
| Saving changes in shared workbooks | Excel Discussion (Misc queries) | |||
Hybrid Mode
