If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
default save as
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! |
#2
|
|||
|
|||
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! |
#3
|
|||
|
|||
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! |
#4
|
|||
|
|||
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! |
#5
|
|||
|
|||
I just tried it myself (didn't try it from the network). Same issue you have.
If you figure it out please post...I will be working on this now myself as well. "johnw" wrote: 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! |
#6
|
|||
|
|||
xl2k changed this behavior--most people like the new behavior.
If you open an existing workbook and do a file|SaveAs, xl97 uses your current folder. xl2k+ uses the folder that contained the existing file. Jim Rech posted a registry tweak that will save to the current folder: http://groups.google.co.uk/group/mic...fbf12fcb6b44ec or http://snipurl.com/hpkj The 10.0 in the registry key refers to xl2002. 9.0 = xl2k 10.0 = xl2002 11.0 = xl2003 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! -- Dave Peterson |
#7
|
|||
|
|||
That did the trick. Thanks Dave!
"Dave Peterson" wrote: xl2k changed this behavior--most people like the new behavior. If you open an existing workbook and do a file|SaveAs, xl97 uses your current folder. xl2k+ uses the folder that contained the existing file. Jim Rech posted a registry tweak that will save to the current folder: http://groups.google.co.uk/group/mic...fbf12fcb6b44ec or http://snipurl.com/hpkj The 10.0 in the registry key refers to xl2002. 9.0 = xl2k 10.0 = xl2002 11.0 = xl2003 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! -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Default Save As | JRC | General Discussions | 2 | March 30th, 2005 05:43 PM |
Change default save as path OL2K3 | Colin | General Discussion | 1 | January 25th, 2005 11:19 AM |
"Save Picture As" quit working | Len | Outlook Express | 3 | August 26th, 2004 11:57 PM |
Changing default "save as type" | Ian | General Discussion | 1 | August 14th, 2004 06:47 PM |
How to change the "save attachment's" default to 'Desktop' | Grampa Bob | Outlook Express | 1 | June 20th, 2004 04:24 AM |