Slow Word linked object updates since moving spreadsheet to Sharepoint

1. Move the Excel file from OneDrive to a local folder (e.g. C:\Project Files\).
Right-click the link in Word → “Edit Link” → “Change Source File “ → Select the local Excel path.
Check “Save linked file” → Click “OK” .
Effect: Avoid round-trip to the cloud, and the update speed is significantly improved.
2. Turn off automatic updating and refresh manually
Hold down the Shift key to open the Word document to prevent automatic updates
Right-click the link → “Update Link” → manually trigger the update.
Effect: The time taken for a single update is reduced from minutes to seconds.
3. Fix OneDrive path redirection
Check the path:
Right click on the link → “Edit Link” → check the “Source File” path.
If the path contains sharepoint.com (https://xxx.sharepoint.com/...) then the path is wrong.
Fix:
Ensure that the Excel file is referenced directly via the OneDrive sync folder (C:\Users\Username\OneDrive\File.xlsx) after the local sync is complete.