Open Workbook

[Pat]

I have a Workbook (Target) that has several Active Links
with another Excel Workbook (Source). Both are of the
same version. When I open the Target Workbook, a message
pops up asking whether I want to update the links. This
is perfectly acceptable. However, when I try to update
the links, another message pops up indicating that the
links cannot because the Source workbook needs to
be 'Recalculated'. I don't want to have to have to open
the Source Workbook, recalculate it, save it, and then re-
open the Target Workbook.

Is there anyway I can use code from inside the Target
Workbook to recalculate a the Source Workbook without
actually having to open the Source Workbook?

Thanks

Pat

 

[Jim Rech]

I don't want to have to have to open the Source Workbook, recalculate it,open the Target Workbook.

All this means is that the last time you made a change to Source you did not
calculate it before it was saved. This you have to do if you want to link
workbooks. If remembering to do this is a problem you might set Recalculate
Before Save on under Tools, Options, Calculation.


--
Jim Rech
Excel MVP
|I have a Workbook (Target) that has several Active Links
| with another Excel Workbook (Source). Both are of the
| same version. When I open the Target Workbook, a message
| pops up asking whether I want to update the links. This
| is perfectly acceptable. However, when I try to update
| the links, another message pops up indicating that the
| links cannot because the Source workbook needs to
| be 'Recalculated'. I don't want to have to have to open
| the Source Workbook, recalculate it, save it, and then re-
| open the Target Workbook.
|
| Is there anyway I can use code from inside the Target
| Workbook to recalculate a the Source Workbook without
| actually having to open the Source Workbook?
|
| Thanks
|
| Pat