Updates Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I get linked workbooks to update without opening each workbook? For
example, if workbook A, passes data to workbook B, and B passes data to
workbook C, how can I change data in workbook A and open workbook C (without
opening workbook B) and have the changed data reflected?

TQ
Param
 
You can't. Workbooks update there links when they are opened. Closed
(Passive) files don't perform activities on their own. To the best of my
knowledge, Excel doesn't try to track down links beyond accessing the
information currently in the closed workbook. (The next level)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Pulling data from another workbook 2
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Excel Links Updates in 2003 7
Link To File That No Longer Exists 1
Compile data from several workbooks 1
Workbook causes calculation errors 2

Back
Top