Set a default save location
You can specify the default location in which files will be saved. Click on the "File" tab in the top left hand corner and select "Options" from the left-hand menu. (In Excel 2007, click the Windows button, then on the bottom of the dialogue box that opens, select Excel options.) Choose "Save" from the left-hand menu. Enter the location where you'd like files to be saved in the "Default File Location".
www.thinkreliability.com