External book reference issue

[Fizzz]

Hello,

Guys I am having an issue with a formula that makes reference to an external workbook. The formula in book A works when book B is open. But when I close the book, and try to run the formula again, it stops working.

Is there a way for this to work without both books being open?

 

[Fizzz]

Any help guys?

 

[VoG]

Better post your formula. Some functions, such as INDIRECT, won't work with closed workbooks.

 

[Fizzz]

I am using Index for the formula.

The formula is INDEX('\\Main folder\folder\Card RECEIVED\Master List.xlsx'!Table1[Card Number],MATCH([Midas ID / Affiliate acct. '#],'\\Main folder\folder\Card RECEIVED\Master List.xlsx'!Table1[Account],0)

 

[Andrew Poulsom]

Structured references don't work with a closed workbook:

Links to data tables residing in external files display #REF!

 

[VoG]

Look here [SOLVED] Using Index and Match functions on a closed workbook