My boss and I recently had Office 2010 installed on our computers. In XP he was able to set the directory that popped up when he clicked the "open" button in excel to the drive he wanted to use (as opposed to, say, "my documents") I have never done this, so I don't even begin to know where to look. My internet searching brought up articles about how to change the default save location but nothing about changing the default open directory.

Does anyone know how to do this?

Should be under FILE > OPTIONS > SAVE > DEFAULT FILE LOCATION

Ahhh.... So the "save" thing works for the open path as well... Excellent.

Thank you! :D