File Format & Compatibility

How to Preserve Excel Hyperlinks When Moving to OneDrive

Maira Mehtab Sep 22, 2026 869 views

Question details

The user wants to know why Excel hyperlinks change or become invalid when workbooks are moved to OneDrive, and how to prevent this issue from happening.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Moving or copying Excel workbooks containing hyperlinks to OneDrive or another external drive.
Observed behavior: Relative hyperlinks break and become invalid after the file is copied to a new drive location.

Before you start

Before moving your files, verify whether your Excel hyperlinks are currently formatted as relative or absolute paths to anticipate how they will behave when transferred to a cloud drive.

Solution 1Recommended

Use the Save As Command Instead of Copy

Using the 'Save As' command forces Excel to recalculate and maintain hyperlink paths correctly when saving to a new drive.

Office applications typically store links to files on the same drive as relative paths. When you simply copy and paste an Excel file to a different drive, such as OneDrive, these relative paths do not update automatically and will break.

Open the original workbook

Launch your Office application and open the original Excel workbook containing the working hyperlinks.

Navigate to the Save As menu

Click on 'File' in the top-left corner of the ribbon and select 'Save As' from the left sidebar options.

Select the OneDrive destination

Choose your OneDrive folder or the new destination drive as the target save location.

Save the file

Click 'Save' to transfer the file. This process automatically recalculates and preserves your link structures for the new environment.

Test Your Hyperlinks: After saving, open the new file from OneDrive and test a few hyperlinks to ensure they resolve to the correct destinations.

Free Microsoft Office alternative

Try WPS Office for Seamless Spreadsheet Management

If you frequently struggle with broken links and complex file management in Microsoft Office, consider switching to WPS Office. It is a free, lightweight, and highly compatible alternative that makes managing cross-device spreadsheets a breeze.

1. Download WPS Office: Visit the official WPS website to download the free installation package.
2. Install the software: Follow the on-screen instructions to install WPS Office on your computer.
3. Open your files: Open your existing .xlsx files directly in WPS Spreadsheet with perfect format retention.

Fully compatible with Microsoft Excel (.xlsx) formatsLightweight installation with a user-friendly interfaceReliable hyperlink management across local and cloud storageBuilt-in cloud sync capabilities for seamless device transitions

microsoft office alternative - wps office

Frequently Asked Questions

What is the difference between relative and absolute hyperlinks in Excel?

An absolute hyperlink contains the full file path (e.g., C:\Documents\file.xlsx), while a relative link only contains the path relative to the current workbook's location. Relative links often break when the main file is moved to a different drive.

Can I fix hyperlinks that are already broken in OneDrive?

If the links are already broken, you will need to edit them manually by right-clicking the cell, selecting 'Edit Hyperlink', and pointing them to the correct file location. Alternatively, you can use the 'Find and Replace' tool to update the broken base paths in bulk.

Does moving an entire folder prevent hyperlinks from breaking?

If all linked files are kept within the exact same folder structure and the entire parent folder is moved together, relative hyperlinks usually remain intact. However, using the 'Save As' method is still the most reliable way to prevent issues when changing drives.

Document & File Issues