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: 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.

www.000webhost.com