Hello Everyone,

I have some formulas in a destination workbook that reference data in a source workbook.

QUESTION 1:

I would like to disable the automatic update of these links, and instead require the update process to be triggered manually. But the manual radio button in the Edit Links window of the destination workbook is grayed out. What to do?

QUESTION 2:

As you might infer from the first question, the update process for these links is currently set (stuck) to automatic. My understanding is that all cells in the destination workbook with external references to the source workbook should not be automatically updated or otherwise recalculated, unless and until the source workbook is opened. However, I seem to be experiencing a different behavior. For example, I created a column in the destination workbook populated with versions of this formula:

=IFERROR(IF(LEN(INDEX('AssocExecs master 3.5.xlsx'!Table1[#Data],MATCH(G12,'AssocExecs master 3.5.xlsx'!Table1[[ ORGANIZATION]],0),4))>0,"Yes","Error"),"No")

When the destination workbook is first opened, with the source workbook closed, the destination workbook shows a mix of "Yes" and "No" values, representing the last correct values when both workbooks were simultaneously open.

However, without ever opening the source workbook, the values returned by these formulas will all change to "No" after a few minutes (or some unrecognized event).

What might be happening?

Cheers,

Jay