Update data in closed workbook

[pruleone]

Hi,

I have two different workbook.
One where I have to write all data - so called inserted data.
And other workbook, where are data from internet (external data) and also some data are linked with first book.

also I have in second workbook some graphics, which are getting info from first book and giveing chart back to first book.
There are problem - when second sheet are closed, then I can't get graph with new existing info.

Is there any possibility to make somekind of macro or someting like this, to make data updateing between book one and two?

For example some kind of putton, which I have to press to get graphs with new data?

 

[Bong]

I would have a sheet on the "first" workbook with links to the appropriate ranges in the "second".

_________________
Bob Rashkin