Indirect worksheet function with closed workbook

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:43 PM GMT

Question

As indirect worksheet function cannot display the linked cell from closed workbook, is there any work around solution? Please suggest me, Edward

Answer

Edward

The chances are your reference in the link does not describe the complete path to the linked cell.

For example If I create a link from workbook2 to workbook1 with them both open the link will look like this. =+[Book1.xls]Sheet1'!$A$2

Assume then that I save Book1 to the desktop and close it. Now the link must tellexactly where the Book is so the link needs to look something like this

=C:\Documents and Settings\Compaq_Administrator\Desktop\[Book1.xls]Sheet1'!$A$2

Now the formula describes the full path, givingthe location of the workbook. (Of course the workbook was saved to the desktop in this example)

To create the full path you can first create your formulas with both workbooks open, then save the workbook that your are linked to, in this case that would be Book1. Your formulas will automatically change to reflect the full path.

If you have closed both workbooks, then when you reopen your workbook with the links in itwill ask if you want to update the links. Answer yes and any changes that have been made will be reflected.

Advertisement

©2017 eLuminary LLC. All rights reserved.