Excel should open documents in the folder of the current file
 

It would be nice for office programs to have an alternate setting for what
folder a user is directed to when trying to open a new document. Currently
one is directed to the last folder opened, but it would be nice to be
directed to the folder of the file currently in use. For an office user
constantly moving to different folders, it is frustrating to be working on
one account and have to be directed to the last account you were working on
when you try to open other documents.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...ic.excel.setup