Hi everyone,

First post here as I've usually been able to find the answer to any question I've had just by searching the site... so a thanks is in order.

My problem is that I have two separate workbooks. Workbook A is small database containing the details of various projects we are currently working on. It is maintained by a separate department and is only accessed in read only mode. Workbook B is a template that populates various fields by using an Index Match formula linked to workbook A once the Project Reference code is entered into the template.

Now this is where the issue arises. If I only open workbook B and enter the reference number, the link works without any issues whatsoever. However, if I have workbook A open, then open workbook B and enter the reference number, no data gets pulled through to workbook B.

I have checked the formula and there is no issues with that, especially as it works when wbA isn't open. I have checked to make sure the calculation options are set to automatic. I have also tried to update the links with both workbooks open, but that doesn't seem to help either.

I imagine it is a really easy solution, I have just never come across it in all my years working with excel.

Any help would be greatly appreciated.