» Using a Workspace to Open a Number of Workbooks at Once in Excel 2007

Saving open workbooks in a workspace enables them to be opened together. 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 workbooks
2. Select File -> View -> Save Workspace (in Windows Group).
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 Select File -> Open.
2. Select the workspace name to open the files.