Forum Discussion
Mass Update SharePoint File Location in Excel Formulas
We recently migrated our Google Drive folders to Teams channels, and initially all Excel formula file references worked fine.
However, a user reported one of his files was not updating formulas that linked to another file in Teams. It turns out the file path in SharePoint has changed:
- Old path: oursite.sharepoint.com/Pricing
- New path: oursite.sharepoint.com/sites/Pricing/Shared Documents/General/Pricing
We now have several hundred Excel documents with formulas that reference the old path and I need to bulk update all of them to point to the new path. Does anyone know a way to either update all these formulas (through Teams or SharePoint)?
1 Reply
AbzacRoss Microsoft don't provide anything to bulk update links within documents, but there is a third party app called ReplaceMagic that will do it.
