I've just come searching for an answer to exactly the same problem. I've got
a workbook with links to another workbook that do update, and to another that
don't (unless I've opened it first; doesn't matter if it's subsequently
closed again). I'll be well pleased if someone can answer it.