» 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:
Recommended Books:
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
- Monte Carlo Methods in Finance
- Microsoft Windows XP Inside Out
- The Fall of Advertising and the Rise of PR
- Business Plans For Dummies®
- Microsoft Excel 2002 Visual Basic for Applications Step by Step
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).