When you know that you’ll be using a particular workspace for some time in your Excel work, you can speed up the process of setting up your work environment by having Excel automatically open the workspace file when you launch the program.

The process for doing this involves two parts: You need to designate a folder on your computer as the alternate startup folder, and then you have to save the workspace file in that folder. Any Excel file that you save in the XLSTART folder provided by Microsoft and saved in the:
C:\Program Files\Microsoft Office\Office11
folder automatically opens when you launch the program.

Excel enables you to designate an alternate folder for automatic startup. It is recommended to save the workspace file you want automatically opened in the alternate startup folder that you specify because no matter where you put this folder it just has to be easier to find than Microsoft’s XLSTART folder!

To designate a folder as the alternate startup folder, follow these steps:

1. Choose Tools -> Options and then select the General tab in the Options dialog box.
2. Select the At Startup, Open All Files In text box and then enter the path to the folder where you’re going to save your workspace file. Type the folder’s pathname in this text box.
3. Click OK to close the Options dialog box.

After you designate your alternate startup folder, follow these steps to save the workspace file that you want Excel to automatically open on startup:

1. Choose File -> Save Workspace to open the Save Workspace dialog box.
2. From the Save In drop-down list box, select the folder you designated as the alternate startup folder.
3. Click Save to close the Save Workspace dialog box.

After you save the workspace file in your Excel alternate startup folder, each time you start Excel the program opens the file and uses its information to load your workbook files, arrange their windows, and invoke their display settings. When you finish your work with the workbooks opened in the workspace and no longer want to see them every time you launch Excel, you need to move the workspace file out of the alternate startup folder into another folder on your hard disk, or, if you’re really sure that you have no need for the workspace, you can delete it by moving it into the Windows Recycle Bin.