off_sheet links over lan update only when source sheet open
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: off_sheet links over lan update only when source sheet open

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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

  2. #2
    New Member
    Join Date
    Mar 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com