ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   How to change options for saving when old directory(network) gone (https://www.excelbanter.com/setting-up-configuration-excel/104293-how-change-options-saving-when-old-directory-network-gone.html)

Mel Ackerman

How to change options for saving when old directory(network) gone
 
I have moved my computer from a network to home and cannot change the EXcel
"tools" "options" ( such as automatice Save to file) as EXcel still looks for
the old network directory. Is reconnecting to the network my only option??

Mark

How to change options for saving when old directory(network) gone
 

Mel Ackerman wrote:
I have moved my computer from a network to home and cannot change the EXcel
"tools" "options" ( such as automatice Save to file) as EXcel still looks for
the old network directory. Is reconnecting to the network my only option?


I may be missing your warning but I'll take a shot as what I think you
said didn't make sense. Select: TOOLS...OPTIONS...(Select the GENERAL
Tab)...Then change the entry besides the label..."Default File
Location"

That should do it for ya.


Mel Ackerman

How to change options for saving when old directory(network) g
 
I have tried that but every time I try to open the General tab is says
"cannot find M\data file" as i no longer have an "M" directory!! ie it won't
let me make changes because I no longer have an M directory

"Mark" wrote:


Mel Ackerman wrote:
I have moved my computer from a network to home and cannot change the EXcel
"tools" "options" ( such as automatice Save to file) as EXcel still looks for
the old network directory. Is reconnecting to the network my only option?


I may be missing your warning but I'll take a shot as what I think you
said didn't make sense. Select: TOOLS...OPTIONS...(Select the GENERAL
Tab)...Then change the entry besides the label..."Default File
Location"

That should do it for ya.



Mark

How to change options for saving when old directory(network) g
 

Mel Ackerman wrote:
I have tried that but every time I try to open the General tab is says
"cannot find M\data file" as i no longer have an "M" directory!! ie it won't
let me make changes because I no longer have an M directory


Try remapping the M Drive to something local then. It should free
things up. I assume you dont need the drive anylonger anyhow. Even if
you do you can always remap it later.



All times are GMT +1. The time now is 11:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com