Tip Printed from ExcelTip.com

---

Using a Workspace to Open a Number of Workbooks at Once


Saving open workbooks in a workspace enables them to be opened together at a later time. This is important when working with linked workbooks.

To save workbooks in a workspace:

1. Open all the workbooks you want to store in the workspace, and close any other workbook not being stored in the workspace.
2. From the File menu, select Save Workspace.
3. In the Save Workspace dialog box, type the workspace name in the File name box and click Save.

To open all workbooks at once using the workspace:

1. Press Ctrl+O to open the Open dialog box.
OR
From the File menu, select Open.
2. Select the workspace name to open the file.