OneDrive for Business file server migration troubleshooting for finance folders: breaks recent links

When you migrate finance folders from an on-premises file server to OneDrive for Business, users often find that recent document links in Office apps, email attachments, and shared shortcuts stop working. This happens because the original file paths change from a UNC path like \\fileserver\finance\Q4_report.xlsx to a cloud-based URL in OneDrive. The broken links cause errors such as “Cannot find the specified file” or “This link is no longer valid” when users click them. This article explains why these link breaks occur during migration, provides step-by-step methods to preserve or redirect file references, and lists common failures and their fixes.

Why Finance Folder Migration Breaks Recent Links

When files move from a file server to OneDrive, every file receives a new URL. Windows and Office applications store recent file references as absolute paths. If the path changes, the link breaks. Finance folders often contain deeply nested subfolders and long file names, which increases the likelihood of broken links. The root cause is that the migration tool does not update the file path metadata in Office’s recent file list, email attachments, or SharePoint document library references by default.

How Office Stores Recent Links

Microsoft Office applications store recent files in the Windows registry under HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\\File MRU. These entries contain the full original path. When the file moves, the registry entry still points to the old location. The application tries to open the file at the old path, fails, and displays an error. Finance users who rely on quick access to spreadsheets or reports through the “Recent” list in Excel or Word will see these broken links immediately after migration.

Why Finance Folders Are Especially Vulnerable

Finance folders often have strict permission sets, complex folder structures, and files that are referenced across multiple departments. For example, a budget spreadsheet might be linked from an email, a SharePoint document library, and a Power BI report. Migrating such files without updating all references causes widespread link failures. Additionally, finance teams frequently use “Send to Mail Recipient” or “Copy as Path” features, which embed the original UNC path in the message or document.

Steps to Fix Broken Links and Prevent Future Breaks

Below are three methods to fix broken links after migration. Use Method 1 for existing broken links in Office recent files. Use Method 2 for bulk link replacement during migration. Use Method 3 to prevent new links from breaking after migration.

Method 1: Clear and Rebuild Office Recent Links

1. Close all Office applications
   Ensure Excel, Word, PowerPoint, and Outlook are closed. Running applications keep the registry locked and changes will not apply.
2. Open Registry Editor
   Press Windows + R, type regedit, and press Enter. Click Yes if prompted by User Account Control.
3. Navigate to the File MRU key
   Go to HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\File MRU. Repeat for Word and PowerPoint if needed. The key name varies by app: Excel, Word, PowerPoint.
4. Delete the broken entries
   Right-click each value that contains the old UNC path (e.g., \\fileserver\finance\...) and select Delete. Confirm the deletion. Do not delete the entire key, only the values pointing to the old server.
5. Open the migrated file in OneDrive
   Navigate to the file in OneDrive via File Explorer or the OneDrive web interface. Double-click the file to open it. Office adds the new OneDrive URL to the recent list automatically.
6. Verify the fix
   Open the File menu in the Office app, click Open, and check the Recent list. The file should now show the OneDrive path and open without errors.

Method 2: Use SharePoint Migration Tool with Link Fix

1. Download and install the SharePoint Migration Tool
   Go to the Microsoft 365 admin center, select Migration, then SharePoint Migration Tool. Download and install the latest version.
2. Create a new migration task
   Open SPMT, click Start, then select File share as the source. Enter the UNC path to the finance folder, such as \\fileserver\finance.
3. Set the destination to OneDrive
   Choose OneDrive for Business as the destination. Enter the target user’s OneDrive URL, for example https://yourtenant-my.sharepoint.com/personal/user_domain_com.
4. Enable link fix
   In the Settings pane, check the box Fix file links in documents. This option scans Office files for old UNC paths and replaces them with the new OneDrive URLs during migration.
5. Run the migration
   Click Start to begin. Monitor progress in the SPMT dashboard. After completion, open a migrated file and check that internal links (e.g., hyperlinks to other files) point to the OneDrive location.

Method 3: Redirect Finance Users’ Known Folders to OneDrive

1. Open Group Policy Management Console
   On a domain controller or management workstation, open Group Policy Management Console. Create a new GPO or edit an existing one linked to the finance department’s OU.
2. Configure folder redirection
   Navigate to User Configuration > Policies > Windows Settings > Folder Redirection > Documents. Set the Setting to Basic – Redirect everyone’s folder to the same location.
3. Set the target folder path
   Under Target folder location, choose Redirect to the user’s OneDrive for Business account. This automatically maps the Documents folder to the user’s OneDrive.
4. Apply the GPO
   Run gpupdate /force on finance users’ computers. After the next sign-in, the Documents folder points to OneDrive. New files saved to Documents will use the OneDrive path, preventing future link breaks.

If Links Still Break After Migration

OneDrive Sync Shows “This file can’t be synced” for Finance Files

This error occurs when the file name or path exceeds 400 characters. Finance folders often have deep nesting. Shorten folder names or move files to a shallower folder structure. Use the OneDrive admin center to set file name length limits to 256 characters for new uploads.

Excel Links to Other Finance Workbooks Still Broken

Excel external references store the full path. After migration, the path changes. Open the workbook, go to Data > Edit Links, select the broken link, and click Change Source. Browse to the new location in OneDrive. For many workbooks, use a PowerShell script to replace paths in the .xlsx file (which is a ZIP archive) by editing the xl\externalLinks XML.

Email Attachments with Old UNC Links

Emails sent before migration contain UNC paths in the body or as attachments. Search Outlook for the old server name using Ctrl + E and type fileserver. Manually update each email or create a mail flow rule in Exchange Online that replaces the old server URL with the new OneDrive URL. This requires PowerShell and is best done by an Exchange administrator.

File Server Path vs OneDrive URL: Key Differences

Item	File Server Path (UNC)	OneDrive URL
Format	\\server\share\folder\file.xlsx	https://tenant.sharepoint.com/personal/user/Documents/folder/file.xlsx
Access method	Direct network share	Cloud URL with authentication
Supported in Office recent list	Yes, until link breaks	Yes, after first open
Link fix during migration	Not supported natively	Supported via SPMT link fix option
Permission inheritance	NTFS permissions	SharePoint permission groups

After migration, you can now identify why recent links break and apply three targeted fixes: clearing Office MRU entries, using SPMT with link fix, and redirecting finance users’ known folders. Next, audit the finance team’s most-used shared files and run a link validation report using the SharePoint Migration Tool assessment feature. An advanced tip: create a PowerShell script that scans all .xlsx and .docx files in the migrated folder and replaces any remaining UNC references with the OneDrive URL using the System.IO.Compression namespace to edit the XML inside the Office file package.