» 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 Guide to Understanding Financial Statements
- The 11 Immutable Laws of Internet Branding
- Microsoft Outlook Version 2002 Step by Step (With CD-ROM)
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Special Edition Using Microsoft Access 2002
- Essentials of Accounting and Post Test Booklet 8, Eighth Edition
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).