Is there any way to link specific data in an excel cell to a word document and keep the link live when documents are put into Sharepoint?

Dear @Abby Bailey,

Based on your description, you are using Word's "Paste Special > Paste Link" feature to link Excel data into a Word document. However, when both files are stored in SharePoint or a shared OneDrive location and edited by multiple users, the link breaks. You wonder there is a supported way to maintain a live link between specific Excel cells and a Word document in SharePoint so that updates remain synchronized for all users.

This behavior is expected in many SharePoint Online and OneDrive scenarios because traditional Office object linking (OLE), including Paste Special > Paste Link, was originally designed for local or network file paths. When documents are stored in SharePoint or OneDrive, the underlying file references may change, causing linked Excel content in Word to stop updating correctly.

Here are some suggestions you can refer to: 

Option 1: Store and sync both files from the same SharePoint library

If you need to continue using Paste Link:

1. Store both the Excel and Word files in the same SharePoint library.
2. Ensure all users sync the library using the OneDrive sync client.
3. Open files from the local synced folder rather than from the browser.
4. Create the link after both files are in their final location.

This configuration has been reported to work in some environments, although reliability can vary depending on how users access the files.

Option 2: Use Power Automate and Word content controls

For documents that require collaboration and frequent updates:

• Store the source data in Excel or a SharePoint List.
• Insert content controls in the Word document.
• Use Power Automate to populate or update the Word document automatically.

This approach is more reliable in SharePoint Online environments and is better suited for multiple editors.

Option 3: Use a SharePoint List as the data source

If you are only linking business data (dates, names, statuses, metrics, etc.), consider:

• Storing the data in a SharePoint List.
• Using Power Automate to update or generate the Word document.

This is generally the most scalable cloud-based solution.

I hope information above meet your expectations, feel free to reach out if you have any other questions.

If the answer is helpful, please click "Yes". If you have extra questions about this answer, please click "Comment".   

Note: Please follow the steps in the forum documentation to enable e-mail notifications if you want to receive the related email notification for this thread.