absolute link to another unopened workbook

[yky]

I have a need to always link to, say, A1 in another workbook no matter how that workbook is changed (column A deleted, row 1 inserted, column or row sorted, etc). I can use the following formula:

=INDIRECT("'C:\Users\user1\Documents\[test1.xlsx]Sheet1'!$A$1")

But this only works if test1.xlsx is open. If it is not open, what is displayed is "#REF!". Since some sheets may need to link to more than 10 workbooks, opening all the linked workbooks is a pain.

Anyway to absolutely link to another workbook without opening that workbook? Thanks.

 

[shg]

Find MoreFunc on the web and use INDIRECT.EXT

 

[yky]

Find MoreFunc on the web and use INDIRECT.EXT

Thank you for the reply.

Anyway to install morefunc on Excel 2010?

 

[shg]

I don't know, I don't use MoreFunc or Excel 2010. What does the documentation say?

 

[yky]

I don't know, I don't use MoreFunc or Excel 2010. What does the documentation say?

I have to manually install the add-ins. The automatic installation did not work. Once installed, it works fine. Thanks for the help.

 

[shg]

You're welcome, good luck.