Thanks j i have tried that but does not work,keeps taking the save as
location from the master.works perfect on all pcs running office97.Help!!

"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!