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)?
