Help - Using indirect to return external values

  • Thread starter Thread starter rwong
  • Start date Start date
R

rwong

Hi all,

Hope someone here can help me solve this issue.

I'm updating this summary excel file which pulls in the same data fro
a variety of other excel files. The old file would have direct link
to these files, hence, upon opening, I would get a "would you like t
update links" request.

However, these direct links aren't very flexible, in that if I wante
to add a new sub-file, I would need to manually relink each one. So
wanted to do a =indirect("filepath/[name]sheet1!A1") type function
however, indirect only returns data for external links if the fil
containing the reference is open.

I don't want to have to open all 30+ files to update the main file..
Is there some workaround for this???

Thanks in advance..
 
Thanks for that - but I am trying to pull entire sets of data... thi
method would prob. be more useful pulling out single data points...

Unless someone can show me how to incorporate this into a huge array o
something, where I can input the file name, path, sheet and cell, an
get all the figures pulled out and put straight into a worksheet...
 
Back
Top