Update Values Window constantly popping up; NamedRange not working?

[SirGruffles]

I've got the below setup, trying to have a filepath reference the workbook name listed in CurrentIndia, highlighted below.

I've named the range officially CurrentIndia in NameManager:

But everytime I edit the formula or re-confirm it, the Update Values window pops up everytime, and I have to manually select the file I have listed under CurrentIndia.
Is there a way for this reference to be pulled automatically so my end user doesn't need to select the file in the window?

Thanks!

 

[Fluff]

Duplicate to: VBA/Formula to reference a Closed Workbook, based on a Dynamic cell reference in current workbook

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.