Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Cell linking problem

  1. #1


    I have a cell in a workbook (lets call it workbook A) containing an OLE link to another application.

    I have a second workbook (lets call it workbook B) which contains a cell whose value should be the same as the OLE-linked cell in workbook A (so I've created a link).

    The problem I have is that the cell in worksheet B won't automatically update the new value of the cell in workbook A (unless I actually open workbook A first - which I don't want to have do every time) - how can I get round this? (Unfortunately, I cannot link workbook B to the other application - its value has to come from worksheet A).

  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Post Thanks / Like
    0 Post(s)
    0 Thread(s)



    Got a bit lost with all the A's and B's but try going to Edit>Links>Upadate Now.

Some videos you may like

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