Linked cells showing #value when source linked file is not open

[piannetta]

Hi, I'm encountering an unusual problem. I have cells in workbook A with links to cells in Workbook B.

When both workbooks are open, everything is fine. But if I close workbook B, the linked cells in workbook A change to an #value error. If I reopen workbook B, the error goes away and the linked value appears.

I don't know why this is happening but it's quite annoying, is there a way to fix this please? I have searched this forum and Google but can't seem to find this issue and a resolution.

I'm using Excel 2016 Office 365 on Windows 10. Both workbooks are stored locally on my laptop.

Cheers,
Pete

 

[Special-K99]

Linked how? Some kind of formula, if so which formulas?

 

[piannetta]

Here is the formula in one of the cells:

=SUMIFS('C:\Users\petei\Documents\WFP\Forecasting\[Master Tracker vFY20.1.xlsm]WeeklyHCPlan'!$E$5:$E$121,'C:\Users\petei\Documents\WFP\Forecasting\[Master Tracker vFY20.1.xlsm]WeeklyHCPlan'!$A$5:$A$121,$G6)/COUNTIF('C:\Users\petei\Documents\WFP\Forecasting\[Master Tracker vFY20.1.xlsm]WeeklyHCPlan'!$A$5:$A$121,$G6)

Pete

 

[Special-K99]

SUMIF/SUMIFS doesnt work on a closed file.
Further info here

https://www.google.co.uk/search?saf...81.0j4......0....1..gws-wiz.....0.TkUIA6NvYcw

 

[piannetta]

Ah right, wow, OK that does suck but good to know.

Cheers,
Pete