SharePoint Document Issues

How to Move SharePoint Documents Without Breaking Hyperlinks

Maira Mehtab Sep 22, 2026 869 views

Question details

The user needs to move thousands of documents between different SharePoint Online sites without breaking the direct document URLs and the Excel formulas that reference those files.

Product: SharePoint Online
Device & OS: not provided
Scenario: Migrating a large volume of files and folders across different SharePoint Online site collections.
Observed behavior: Moving files to a new site changes their direct URLs, causing existing direct document hyperlinks and referenced Excel formulas to break. Sharing links are only preserved in very limited scenarios.

Before you start

Before initiating a large-scale migration between SharePoint sites, conduct a thorough audit of your documents to identify critical Excel formulas and direct links that will be impacted by the unavoidable URL changes.

Solution 1Recommended

Use the Keep Sharing Option and Manually Update Links

Because SharePoint Online inherently changes the direct URL when a file moves to a new site, you must preserve sharing permissions on an individual basis and manually update formula references.

Currently, SharePoint Online does not offer an out-of-the-box method to move multiple documents or folders between sites without breaking direct links. Direct URLs change because the base site address changes.

However, you can use the sharing preservation feature when moving individual files to ensure collaborators do not lose standard access, even though the direct link itself will need to be updated in your Excel sheets.

Select the individual document

Navigate to your SharePoint document library and select the individual file you want to move.

Choose the Move to command

Click on the three dots (ellipsis) next to the file name and select 'Move to' from the dropdown menu.

Select destination and preserve sharing

Choose the new destination site. Before confirming the move, ensure you check the box for 'Keep sharing with the same people'.

Update formulas and direct links

After the file is moved, open any dependent Excel files or web pages and manually replace the old external reference paths with the newly generated document URL.

Limitation on Bulk Moves: The 'Keep sharing with the same people' option does not work for moving multiple files at once or entire folders. Bulk migrations will require a complete manual link rebuild.

Solution 2

Submit Feedback for Native Cross-Site Link Preservation

Since there is no standard fix for this Microsoft limitation, you can request official support from Microsoft for preserving direct hyperlinks during cross-site migrations.

Free Microsoft Office alternative

Try WPS Office for Seamless Document Management and Collaboration

Dealing with broken links and complex migrations in SharePoint can be frustrating. WPS Office offers a lightweight, highly compatible alternative for managing your documents, spreadsheets, and presentations. Enjoy robust cloud storage and seamless collaboration without the steep learning curve or restrictive site boundaries.

1. Download and Install: Visit the WPS official website to download and install WPS Office for your computer or mobile device.
2. Sign in to WPS Cloud: Create or log into your WPS account to access free cloud storage for your collaborative documents.
3. Upload and Share: Easily upload your existing files to WPS Cloud and generate stable sharing links for your team that won't break across different workspaces.

Fully compatible with Microsoft Office formats (Word, Excel, PowerPoint)Built-in WPS Cloud for easy document sharing and centralized team collaborationLightweight application that runs smoothly on Windows, Mac, and LinuxAdvanced spreadsheet capabilities to manage formulas and data references securely

microsoft office alternative - wps office

Frequently Asked Questions

Why do Excel formulas break when I move referenced files in SharePoint?

Excel formulas that reference external workbooks rely on specific static file paths (URLs). When a file is moved to a different SharePoint site, its web address changes completely, causing the external reference to break until you manually update the formula with the new path.

Can I use the 'Keep sharing with the same people' feature for folders?

No, currently SharePoint Online only supports the 'Keep sharing with the same people' option when moving individual files. It cannot be applied to bulk file moves or entire folders.

Is there a way to redirect old SharePoint links to the new site?

Native SharePoint Online does not automatically redirect standard document URLs after a cross-site move. While some third-party enterprise migration tools can map and manage link redirects for web pages, direct Excel formula references typically still require manual updates post-migration.

Document & File Issues