Forum Discussion
Solved
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...
Make sure you do not change the original file name (Data.xlsx).
Whenever a new file is available, make sure to create an archive copy.
- First, take the existing Data.xlsx file and create a copy (Data_Copy_ForArchive.xlsx) of it.
Move that copy to the archive location and rename it using a consistent naming pattern, such as:
- DataArchive1.xlsx, DataArchive2.xlsx, DataArchive3.xlsx, and so on. You can apply a consistent renaming logic for archived files not for the original file.
- Once the archive copy is safely created, you can proceed to overwrite the original file with the new one using the same name: Data.xlsx.
- This will overwrite the existing file in SharePoint (and create a new version if versioning is enabled).
By keeping the file name, the same (Data.xlsx), all existing links in your Word documents will continue to work without breaking.
