Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Aug 2003
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    linking workbooks (XP)

    I am trying to use 3 linked excel workbooks. is there any way to be able to insert/delete entire rows in one of them without having to have all 3 open at once? When i try to do this the closed workbook will still pull from a key cell's exact address instead of reading that it has been moved up or down a cell or two. everything else will update properly if one is closed but this described problem. thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: linking workbooks (XP)

    Excel can only update formulas that refer to other workbooks if the workbook containing the formulas is open. It that workbook is closed, Excel has no way of knowing that it contains formulas that should be updated.

    (Imagine Excel checking all non-opened workbooks on your PC, and if you're on a network, on all network drives you have access to, to check if they contain formulas that should be updated - <img src=/S/nope.gif border=0 alt=nope width=15 height=15>)

  3. #3
    New Lounger
    Join Date
    Aug 2003
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: linking workbooks (XP)

    but if i open the workbook that should have been updated and it asks me to update links, why cant it read that the linked cell has been moved up or down due to row insertion? is there any way to fix this problem or a better way to set things up?

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: linking workbooks (XP)

    If you link in Workbook A to a named range in workbook B (instead of an EXACT cell reference) in workbook B, It should do what you want to achieve, since inserting a row will change the cell reference to the name which is what workbook A is linked to.

    Steve

  5. #5
    New Lounger
    Join Date
    Aug 2003
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: linking workbooks (XP)

    thanks for your help everyone!

Posting Permissions

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