Force Byte - Using Excel workspace file

0 Photo

If you have to work with several workbooks (or Excel files) for an extended period of time, you should save a workspace file in your folder under "C:\User" so that all workbooks will be loaded whenever you open the file. Actually, a workspace file is a snapshot of your current Excel environment and you can use the "Save Workspace" command on the "File" menu to save it.

Excel will note the locations of both the workbooks that are currently open and the many workspace settings so that all the workbooks saved in the workspace file will be opened and all the applicable settings activated automatically. This is very convenient, as you no longer need to open them one by one.

The default filename suggested for a workspace file is "Resume.xlw" but you can use a different name if you follow the file naming rules and refrain from changing the three-letter .xlw extension.

If you like to have all the workbooks opened automatically when you start Excel, you can set it up in four simple steps.

They are:

1. Choose "Options" from the "Tools" menu in Excel

2. Click the "General" tab in the dialog box shown

3. Type the full pathname of your folder containing the workspace file in the "Alternate Startup File Location" edit box, say "C:\User\Police"

4. Click "OK" to close the dialog box

Next time when you start Excel again, all workbooks will be automatically opened simultaneously.

However, if you only want to open one workbook automatically, you can directly save it in "C:\User\Police" instead of first saving it in the workspace file.

You should remember that Excel will open any files stored in your specified folder and so you have to remove any files when you no longer need to open them automatically.

"Sharing IT as it applies to your daily life"