» 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:
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
- Microsoft Windows XP Registry Guide
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
- The Fall of Advertising and the Rise of PR
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
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).