Layout Excel reference - only updates properly when Excel file is closed

I have been using Excel files with multiple sheets to reference in to my Layout drawings for cutting lists (it’s so much faster and easier to edit in Excel than using the Layout tables). My slight niggle is that when I make changes in Excel, save the changes and then ask Layout to update the table reference the only way I can get the changes to show in Layout is by actually closing the file in Excel.

Is this a bug?

I’m using the desktop version of Excel in Office 365 and the file itself is saved on my hard disk locally in a shared OneDrive for Business folder.

Onedrive on the desktop is a shortcut to the cloud, not a ‘real’ location.
Syncing creates multiple temp.files in order to prevent loss of data. Recipe for disaster…