Numbers in linked files changing without updating links (shared source and cache?)

[DavidExcelClay]

There are 2 files. File A has links to a source file and was updated from that source at 10am. File B has links to the same source file and was updated from that source at 5pm. The source file changed between 10am and 5pm. If file A is opened after file B, the data in file B changes as if it looks at the source file version from 10am (with different numbers).


This happens even if the user does not have access to that source file anymore, or if the source file no longer exists.


It also happens if the links are not set to update - the numbers change even when they shouldn't.


Any ideas? Feels like a cache problem but I don't understand.