Forum Discussion

PhreeRun's avatar
PhreeRun
Copper Contributor
Jun 02, 2026

Bulk link updates

First off, apologies if this is in the wrong community. All files are held in the same sharepoint library. So in the library there is an excel file which gets updated a couple of times a year and l...
Document Library
files
SharePoint Online
Usage
virendrak's avatar
virendrak
Steel Contributor
Jun 03, 2026

Can you please explain your scenario with specific examples and file names? That will help me give you a more accurate answer.

If you are replacing the same Excel file and keeping the same name or new name , and overwriting it with the new version / or name, then the link issue in Word can be fixed/automated easily.

But if you are creating a completely new Excel file every time, and moving the old one to an archive, then the situation becomes more complicated.

For example: Let’s say the Excel document currently has ID = 1. You create a new Excel file, and now the new file has ID = 2, and the old file (ID = 1) is moved to the archive. In this case, Word cannot automatically update the links, because the latest document always gets a new ID.

When the file ID changes every time, automation becomes difficult, and a manual approach is often the only reliable option since the “latest” file always has a different ID and name combination.