Mass Update SharePoint File Location in Excel Formulas

New Contributor

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:
  • New path: 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.