File Format & Compatibility

Keep Excel 2010 Hyperlinks Working When Moving Files

Steve KSteve K Nov 14, 2026 868 views

Question details

Keep hyperlinks in an Excel workbook working when the workbook and linked documents are transferred to another computer.

Keep Excel 2010 Hyperlinks Working When Moving Files
Product
Microsoft Excel 2010
Device & OS
not provided
Scenario
An Excel workbook links to Word and PDF files that need to be moved together by flash drive, email, or cloud storage.
Observed behavior
Hyperlinks may stop working on the destination computer when they point to absolute drive paths that are not available there.
Before you start

Place the workbook and its linked Word and PDF files in one folder, or in consistent subfolders. Save the workbook before creating links so that Excel has a location to use as a reference.

Solution 1Recommended

Create Relative Hyperlinks and Move the Entire Folder

Use relative paths to link files in the same folder or its subfolders without relying on a drive letter.

1
Organize the files

In your file manager, place the Excel workbook and linked documents in the same folder. If you use subfolders, keep their names and positions unchanged when moving the folder.

2
Insert a hyperlink

In Excel 2010, select a cell and choose Insert > Hyperlink. Under Existing File or Web Page, enter the document name in the Address box, such as report.pdf, or a relative subfolder path such as Documents\report.docx. Click OK.

3
Check the saved address

Save the workbook, then right-click the linked cell and choose Edit Hyperlink. Check that the address does not depend on a local drive path such as C:\Users\.

4
Transfer and test

Copy the entire folder to the other computer, open the workbook from the copied folder, and click the links. For email, compress the folder into a ZIP file and extract it before testing; for cloud storage, download the folder with its structure intact.

Create Relative Hyperlinks and Move the Entire Folder
Keep the folder structure intact: A relative link depends on the linked file remaining in the same position relative to the workbook. If either file is moved or renamed separately, edit the hyperlink.
Work with portable spreadsheets

Create Portable File Links in WPS Spreadsheet

Use WPS Spreadsheet to open the workbook and create links to documents stored alongside it. Move the complete folder and test the links on the destination computer.

  1. 1. Arrange the files: Place the workbook and linked documents in the same folder, then open the workbook in WPS Spreadsheet.
  2. 2. Add a link: Select a cell and press Ctrl+K or choose Insert > Hyperlink. Enter a relative file name such as report.pdf, or a path to a document in a subfolder, and confirm the link.
  3. 3. Save the workbook: Choose File > Save or Save As and save the workbook in Excel XLSX format in the same folder.
  4. 4. Move and verify: Copy the complete folder to the destination computer, open the copied workbook, and click each link to confirm it opens the intended file.
Create links to Word and PDF files from spreadsheet cellsOpen and save Microsoft Excel XLSX workbooksUse a familiar spreadsheet interface for everyday editingKeep related files together for easier transfers
microsoft office alternative - wps office

Frequently Asked Questions

Why do my Excel hyperlinks break on another computer?

A link may contain an absolute path, such as C:\Users\Name\Documents\report.pdf, that does not exist on the destination computer. Right-click the cell and choose Edit Hyperlink to inspect its address.

Can linked files be stored in a subfolder?

Yes. Enter a relative path such as Documents\report.pdf in the hyperlink Address box, and move the Documents folder together with the workbook.

How do I send the workbook and linked files by email?

Compress the folder containing the workbook and documents into a ZIP file and attach it to the email. The recipient should extract the complete folder before opening the workbook and testing the links.

Where can I check the hyperlink base in Excel 2010?

Choose File > Info > Properties > Advanced Properties, then select the Summary tab. Review the Hyperlink base field for an outdated location.