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



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.



1. Press Ctrl+O to open the Open dialog box.
Or Select File -> Open.
2. Select the workspace name to open the files.