Excel saves files to wrong location

[MsKumara]

We are using MS Office 97 on an NT network. The software is on the local drive, the spreadsheets are kept on the network drive.

Supposing a user has a spreadsheet on P: drive, opens it and works on it and then saves. Then user opens a spreadsheet on Q: drive, works on it and then saves. The spreadsheet on Q: drive is saved to P: drive because that is the location the last spreadsheet was saved to.

Is there any way to force Excel to save to the original location of the current spreadsheet?

 

[JrClown]

MsKumara,
Click on tools\options select the general tab and under "Default file Location" type where you want all files to save (P:\folder) QUOTE OF THE DAY
I'm a firm believer in the theory that people only do their best at things they truly enjoy.

Jr_Clown )

 

[Dreamboat]

MsK. Have you really checked to see if this is the case? Have to tested it on the user's PC? I'm finding it hard to believe unless the drives are not properly mapped.
techsupportgirl@home.com
Brainbench MVP for Microsoft Word

http://www.brainbench.com

 

[MsKumara]

Yes, I tested it on her pc, and then went back and tested it on my own pc to see if it was her user profile. I had the same problem.