Hi,

I have three kinds workbooks linked to each other. "Inputs" is the one
collects all the inputs for 30 models. Then the 30 models use the inputs
(linked to "inputs" file) calculate the results. Finally, all the results of
the 30 models display in one "summary" via links. The inputs get updated time
to time. After every update, I have to open all the 30 model files to update
their linked inputs, so the final summary file can show the new results. Is
it possible to show the updated results in the "summary" without openning
those 30 models?

Thanks,
JW

Edit, links, select all of the links you want to update, then press "update
values".

"jwang036" wrote:

Hi,

I have three kinds workbooks linked to each other. "Inputs" is the one
collects all the inputs for 30 models. Then the 30 models use the inputs
(linked to "inputs" file) calculate the results. Finally, all the results of
the 30 models display in one "summary" via links. The inputs get updated time
to time. After every update, I have to open all the 30 model files to update
their linked inputs, so the final summary file can show the new results. Is
it possible to show the updated results in the "summary" without openning
those 30 models?

Thanks,
JW

In the "summary"? It doesn't work if the source books (30 models) are not open.

"BOONER" wrote:

Edit, links, select all of the links you want to update, then press "update
values".

"jwang036" wrote:

Hi,

I have three kinds workbooks linked to each other. "Inputs" is the one
collects all the inputs for 30 models. Then the 30 models use the inputs
(linked to "inputs" file) calculate the results. Finally, all the results of
the 30 models display in one "summary" via links. The inputs get updated time
to time. After every update, I have to open all the 30 model files to update
their linked inputs, so the final summary file can show the new results. Is
it possible to show the updated results in the "summary" without openning
those 30 models?

Thanks,
JW