off_sheet links over lan update only when source sheet open

Edouard_g · Mar 17th, 2002, 08:58 PM

Hello,

I have the following code:
='\ADMINSTRATORPR-LOG-S1.xls'!S1_Q1_01_volume*S1_Q1_01_mf_fee

but I get #ref and cant' find name errors. what is the problem there?

source and target sheets are all in same directories.help..head explode soon.

thanks for help

Edouard_g · Mar 18th, 2002, 06:43 PM

hello,

it appears that if the named external reference is defined as a formulae (eg sum in this case) the recipient sheet will only update properly if the source is open.

only names defined as single cells will link while source is closed.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 17th, 2002, 08:58 PM	#1
Edouard_g New Member Join Date: Mar 2002 Posts: 7	Hello, I have the following code: ='\ADMINSTRATORPR-LOG-S1.xls'!S1_Q1_01_volume*S1_Q1_01_mf_fee but I get #ref and cant' find name errors. what is the problem there? source and target sheets are all in same directories.help..head explode soon. thanks for help

Mar 18th, 2002, 06:43 PM	#2
Edouard_g New Member Join Date: Mar 2002 Posts: 7	hello, it appears that if the named external reference is defined as a formulae (eg sum in this case) the recipient sheet will only update properly if the source is open. only names defined as single cells will link while source is closed.