Keep Excel 2010 Hyperlinks Working When Moving Files
Question details
Keep hyperlinks in an Excel workbook working when the workbook and linked documents are transferred to another computer.

- 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.
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.
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.
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.
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.
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\.
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.

Repair Existing Absolute Hyperlinks
Use this method when transferred links still point to a drive or folder on the original computer.
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. Arrange the files: Place the workbook and linked documents in the same folder, then open the workbook in WPS Spreadsheet.
- 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. Save the workbook: Choose File > Save or Save As and save the workbook in Excel XLSX format in the same folder.
- 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.

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.




