I copy part of a spreadsheet and "paste Link" as "Microsoft Excel Worksheet Object" in a Word document.
It does not update with the Excel source automatically. It only updates after closing and re-opening.
However when I do the same with another Excel file it does update automatically.
I think the issue must lie with the first Excel file.
Any ideas what to look for?