How to save all open files/workbooks at once in Excel?
For working with lots of opened workbooks, it is painful to go through each workbook and save them manually. In this article, we will show you methods of saving all open workbooks at once in Excel.
Recommended Productivity Tools for Excel
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
With the below VBA code, you can save all open Excel files at once. Please do as follows.
1. Press Alt + F11 simultaneously to open the Microsoft Visual Basic Application window.
2. In the Microsoft Visual Basic Application window, click Insert > Module. Then copy and paste below VBA code into the Module window.
VBA code: Save all open files/workbooks at once
Sub SaveAll() Dim xWb As Workbook For Each xWb In Application.Workbooks If Not xWb.ReadOnly And Windows(xWb.Name).Visible Then xWb.Save End If Next End Sub
3. Press F5 key to run the code, then all opened workbooks are saved at once automatically.
With the Office Tab add-in, you can not only open, read and manage multiple Excel files in a single tabbed window, but also save all opened workbooks at once with the Save All utility. Please do as follows.
After installing Office Tab, all opened workbooks are displayed in a single tabbed window. See screenshot:
For saving all opened workbooks, please right click on a tab, and then click Save All from the right-clicking menu. See screenshot:
Then all opened workbooks are saved at once.
|If this utility is helpful, you can download and try the free trial now!|