#formula link to different workbook with indirect not to reff after wb close#

[daboho]

i have workbook in directori
use indirect (myformula = INDIRECT("'[Book3]week ("&B22&")'!$A$27") but after book3 closed then in book2 become reff
how i can do use indirect different workbook.not reff after source workbook closed
how to replace workbook.name with other workbook.name using indirect in directori not reff after workbook.closed
indirect not ref.png
Attachment 493523

[JBeaucaire]

INDIRECT doesn't work on closed workbooks. You've discovered that. If this is a MUST, then you'll have to install more functionality into your Excel program. Only people with the same installed ADD-IN will be able to use your sheet.

The ADD-IN is called MoreFunc...read all about it here:
http://www.ashishmathur.com/tag/morefunc/

See step #4 of that page for instructions on downloading and installing

Go into TOOLS > ADDINS and activate MoreFunc.

Now you have many, many new functions available to you. Any place you used INDIRECT, now use INDIRECT.EXT instead and it will work on closed workbooks.

[daboho]

Jbeaucaire my excel 2013 64 bitt