» Using a Workspace to Open a Number of Workbooks at Once in Excel 2007
CATEGORY - Excel Worksheet, Workbook
VERSION - Microsoft Excel 2007
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.
Book Store:
Error dialog box "This extension can not be used with the selected file type. Change the file extension in the File name text box or select a different file type by changing the Save as type." (but there are NO OTHER file types to choose).