Forum Discussion
Slow Word linked object updates since moving spreadsheet to Sharepoint
My company does engineering projects where the project deliverables consist of a Word document with 20-60 linked objects (numbers, tables, and charts) from a large companion spreadsheet. Since the document and the spreadsheet evolve together, we need live links rather than static pastes.
Since migrating to SharePoint from our homegrown document management system, we're facing major performance issues. Word seems to ignore the local OneDrive copy, and hits SharePoint separately for each linked object, requiring about 15 seconds per link over a symmetric gigabit connection. A 60-link document needs 15 minutes to update!
The slow update issue persists even when:
- Using a brand new document containing nothing but the handful of link objects.
- Breaking external links in the source spreadsheet.
- Pointing links to the local OneDrive copy (Word seems to refactor these links to the corresponding SharePoint URL).
The problem disappears when links are changed to reference a local copy of the file, provided it's not within the OneDrive folder.
I'm seeking advice on:
- Whether this is a known issue with linked objects on SharePoint/Onedrive.
- Possible configurations or optimizations to improve performance.
- Alternative workflows for handling large linked documents more efficiently in SharePoint.
Thank you for your help!