Change the Default File Location in MS Excel
Many users find that they tend to open workbooks from the same folder on their computer. If that Windows Vista folder isn't Documents (My Documents in Windows XP), you can change the folder that Microsoft Office Excel 2007 displays when you want to open or save a workbook. Here’s how:
1. Click the Office button.
2. Click Excel Options.
3. In the left column, click Save.
4. Type the desired location in the Default file location box.