software

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 quot;calculationquot;
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..Hi,

I don't think so. Excel needs to open the file to refresh its links amp; hence
recalculate. You can stack 2 files but not three.

You could use the macro recorder to record yourself opening amp; recalcing amp;
saving the files ... so you would not have to do it manually.

Regards,

Chris.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Masterquot;Vellarianquot; wrote:

gt; Hi,
gt; I hope anyone can give me some advice..
gt;
gt; I have file Book3.xls (summary) which linked to Book2.xls (calculation), and
gt; Book2.xls is linked to Book1.xls (source data).
gt; I often make changes in Book1.xls.
gt; Can I get the updated data when I open Book3.xls without having to open
gt; Book2 ?
gt; Is it possible for Excel to update its data without opening the quot;calculationquot;
gt; file as stored in Book2.xls?
gt;
gt; In fact, there are hundreds of Book2.xls for hundreds of different item
gt; calculation, they made my head swam everytime I have to re-open them one by
gt; one..
gt; Help me please...
gt;
gt; Thank you so much for everything..
gt;