How to Fix Excel Links to PDF Files Not Working for Other Users
Question details
Users are unable to open PDF hyperlinks in a shared Excel workbook, even though the links work perfectly for the file creator.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Sharing an Excel file containing hyperlinks to external PDF documents with colleagues or clients.
- Observed behavior
- PDF links work for the file owner but fail, break, or show an error when clicked by other recipients.
Check if the PDF file is saved on your local hard drive (like C:\Users\...) instead of a shared network or cloud folder, as local paths will inevitably break for other users.
Upload and Link via Cloud Storage
Ensure both the Excel file and the PDF are saved in a mutually accessible cloud location like OneDrive or SharePoint.
When you link to a local file, the hyperlink retains your specific computer's directory path. Other users cannot access your local C: drive. By uploading the PDF to a cloud service, you generate a web link that anyone with proper permissions can access.
Save your PDF file to a shared cloud folder, such as OneDrive, Google Drive, or SharePoint.
Right-click the uploaded PDF file in your cloud storage and select 'Share'. Ensure the intended recipients are granted 'View' or 'Edit' access.
Copy the shareable web link of the PDF file generated by the cloud storage service.
Open your Excel workbook, select the target cell, go to 'Insert' > 'Link' (or press Ctrl+K), and paste the shareable web link into the Address bar.
Embed the PDF Directly into Excel
Instead of linking to an external file, embed the PDF directly into the Excel workbook so it travels with the file.
Use WPS Spreadsheet to Share Excel Files Seamlessly
WPS Office provides robust cloud collaboration tools, making it easy to share spreadsheets with embedded or linked PDFs without worrying about broken paths or access errors.
- 1. Open the file: Launch WPS Spreadsheet and open your workbook.
- 2. Insert the PDF: Go to 'Insert' > 'Object' to embed a PDF directly, or use 'Insert' > 'Hyperlink' to link to an online file.
- 3. Save to WPS Cloud: Save the workbook directly to your WPS Cloud space to ensure it is accessible online.
- 4. Share the document: Click the 'Share' button in the top right corner to generate a collaborative link with specific access permissions for other users.
Frequently Asked Questions
Why does the hyperlink path change to a local drive letter?
Excel sometimes uses relative paths. If the PDF is stored locally, Excel automatically maps the path to your local directory (like C:\). Uploading both files to a shared online folder prevents this issue.
Can I link a PDF stored on my local company network drive?
Yes, provided the recipients are on the same local network and have permission to access that specific network folder. Always use the UNC path (e.g., \\server\folder\file.pdf) instead of a mapped drive letter (like Z:\), as drive letters can vary between users.
What happens if the PDF file size is too large to embed?
Embedding large PDFs will significantly increase the Excel file size, potentially causing performance issues or making the file too large to email. For large documents, it is highly recommended to upload the PDF to cloud storage and share the hyperlink instead.
