In Excel, where do I change the default folder location at, so instead of,
when the user clicks file/open, opening My Documents it would open something
like I:\data\users\username.
This is in Office 2007

Click on the big "Office Button" in the top-left corner.
At the bottom of the menu, click on the "Excel Options" button.
In the Excel Options Window, click on "Save" located on the left side.
You should see the default file location setting here.

HTH,
Elkar



"Dale" wrote:

In Excel, where do I change the default folder location at, so instead of,
when the user clicks file/open, opening My Documents it would open something
like I:\data\users\username.
This is in Office 2007

1.. Click the Microsoft Office Button and then click Excel Options.
2.. Click Save.
3.. Under Save workbooks, type the path in the Default file location box.
Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)
If You Can't Excel with Talent, Triumph with Effort.


"Dale" wrote in message
...
In Excel, where do I change the default folder location at, so instead of,
when the user clicks file/open, opening My Documents it would open
something
like I:\data\users\username.
This is in Office 2007