Remember workbooks To open using a workspace

To reduce the time in opening more than one workbook.You need to open seven files in order to prepare a weekly report. It is tedious to open all seven workbooks.

Open the seven workbook fi les and save them as a workspace. Follow these steps.

1. Open the workbooks and then select File –> Save Workspace.

2. Give the workspace file a name, such as SevenFiles. That file saved will have an .xlw extension instead of.xls.

3. You can now close Excel and open SevenFiles.xlw. All seven workbooks will open at once.

This workspace does not actually store the seven files, but only points to them. If you were to move one of the seven files to a new folder using Windows Explorer, Excel would not be able to open that file.

Excel does not remember the arrangement of the workbooks in the workspace. Although your original workbooks may have been maximized, Excel might open them in a tiled arrangement. Choose the Maximize icon at the top of one workbook to return all workbooks to their original maximized state. This problem was worse in Excel 97, where Excel would frequently forget the zoom and frozen panes in the workspace.