Wanting to use INDIRECT without opening external sheet

  • Thread starter Thread starter Walter
  • Start date Start date
W

Walter

I would like to use the INDIRECT function to bring in
values from another (user named) spreadsheet, however I do
not want the source spreadsheet opened.

According to HELP it needs to be opened. Is there a way to
do this without having to resort to VBA?
 
Not really.

I assume you want to use indirect because you are building the link
dynamically. If you just want to link to a closed workbook/worksheet, you
don't need indirect

='C:\Myfolder\[My workbook.xls]sheet1'!A1

Will work just fine.

Regards,
Tom Ogilvy
 
If you can reference it directly, without using INDIRECT, that's probably
the only way. Aside from VBA

Bob Umlas
Excel MVP
 
You assume correctly Tom, I would like the reference
created dynamically. How can I do it without opening the
source file?
-----Original Message-----
Not really.

I assume you want to use indirect because you are building the link
dynamically. If you just want to link to a closed workbook/worksheet, you
don't need indirect

='C:\Myfolder\[My workbook.xls]sheet1'!A1

Will work just fine.

Regards,
Tom Ogilvy


I would like to use the INDIRECT function to bring in
values from another (user named) spreadsheet, however I do
not want the source spreadsheet opened.

According to HELP it needs to be opened. Is there a way to
do this without having to resort to VBA?
Click to expand...


.
Click to expand...
 
You assume correctly Tom, I would like the reference
created dynamically. How can I do it without opening the
source file?
Click to expand...

Only with VBA or an add-in such as Laurent Longre's MOREFUNC.XLL, which
includes a function named INDIRECT.EXT which can resolve dynamic links to
closed workbooks most of the time. It works well on my work machine running
NT4SP6 and XL97SR2, but not on my wife's PC running ME and XL2KSP3. It's
simply not possible with worksheet functionality alone.
 
Back
Top