Update Links

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

Guest

Hello,

I have an excel document that is linked to several other excel documents. I
want to be able to enter information into one and have the other documents
that are linked to the data update without having to open the file. Is there
any way to do this?

thanks
 
Let Book1 contain the formula =Book2!A.
With Book1 closed I work on Book2 and save it.
When next I open Book1 I will be asked if I want to update it.
If I send a copy of Book1 to another user without opening it then it will
not have the updated value.
Maybe you could experiment with two books then with 3 and see if you get
the effect you want.
best wishes
 

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

When Does Excel Do The Linking? 1
Excel links in Word 1
Word How can I stop Word 2010 asking permission to update a document with an included file? 0
Excel How to Fix Damaged Excel File That Won't Open? 3
User is not prompted to update links when opening spreadsheet 2
Links Automatically refreshing in Excel 2007 3
#value! in linked document 2
Renaming a file while maintaining links 2

Back
Top