Update data wihout opening the file?

V

Vellarian

Hi,
I hope anyone can give me some advice..

I have file Book3.xls (summary) which linked to Book2.xls (calculation), and
Book2.xls is linked to Book1.xls (source data).
I often make changes in Book1.xls.
Can I get the updated data when I open Book3.xls without having to open
Book2 ?
Is it possible for Excel to update its data without opening the "calculation"
file as stored in Book2.xls?

In fact, there are hundreds of Book2.xls for hundreds of different item
calculation, they made my head swam everytime I have to re-open them one by
one..
Help me please...

Thank you so much for everything..
 
R

Rich Mcc

not sure if this is the best way,, but could you not set a on save macro
that auto opens and closes book 2 when you save book
 

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

How to Refer to Another Excel Workbook 1
Remove end folder from path found with ThisWorkbook.Path command ? 9
Update data without opening file? 1
Find WkBk Path, Then use this path to open another WkBk in Subfold 10
How to Copy from One File to Another File 4
How to refer to the specified sheet in the workbook? 1
selecting values form multiple excel files into an excel worksheet 1
Automatically Excuting a Macro in a different workbook ? 10

Top