ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Saving Workbooks (https://www.excelbanter.com/excel-discussion-misc-queries/183202-saving-workbooks.html)

Jamad

Saving Workbooks
 
Hi,
I want to save all my opened workbooks once without having to be saving and
closing each workbook individually. Thanks

Bob I

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



Kevin B

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



All times are GMT +1. The time now is 04:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com