Linking graphs to other files

[BMil8]

There may be a simple answer to this one: I have a number of different files which I use to report performance statistics to different departments. I need to make one summary file that takes one graph from each of these files. Is there a way to link the graphs so the summary file automatically updates? Or do I need to create 51 new graphs in my new file?

Thanks,
Brian

 

[Dannyh1]

Hi

You could do it by creating a 'Graph info' sheet in your workbook that links to all other workbooks & then create a macro that opens & closes all workbooks so links update.

or

Creating a 'Graph info' sheet in your workbook that links to all other workbooks using function INDIRECT.EXT (available via Morefunc download). However referencing 51 workbooks I think will be quite slow.