Thanks J I have tried that,but when the master is called up ,changed and then
"file save as" it ignores the users settings,using the master instead,this
did not happen in excel97,sending me mad!

"jeridbohmann" wrote:

Tools / options
General tab.
Default file location. Change it to whatever you want.

"johnw" wrote:

when we opened an excel from our server via office 97adn then saved using the
save as function ,it would take the perticular pcs current directory.Now on
using excel2003 it only seems to default the directory in the excel we are
opening.This is causing much work as 1 master sheet is used and saved by 15
diff.users in their own default folders.Is this how 2003 works or have we
missed a setting?
Help!