How to Keep Excel PDFMaker Links as File Links Instead of Web Links
Question details
The user wants to prevent local or network file links in Excel from being converted to HTTP/HTTPS web links when generating a PDF.
- Product
- Microsoft Excel, Adobe Acrobat
- Device & OS
- not provided
- Scenario
- Exporting a multi-page Excel worksheet containing local file links into a PDF format using the Acrobat PDFMaker add-in.
- Observed behavior
- When the worksheet spans more than one page, PDFMaker converts the file links into web links, causing them to open in a web browser rather than opening the target file in Acrobat or the default local application.
Ensure that both your Microsoft Office suite and Adobe Acrobat are updated to their latest versions, as this hyperlink pagination bug is occasionally addressed in software patches.
Use Excel's Built-In PDF Export Feature
Bypass the Adobe PDFMaker add-in entirely by utilizing Excel's native PDF conversion tool, which often preserves file link paths more accurately.
The Acrobat PDFMaker add-in can sometimes misinterpret hyperlink targets when recalculating page breaks for multi-page documents. Using Excel's native engine avoids the PDFMaker pagination logic.
In your Excel workbook, click on 'File' in the top-left corner, then select 'Export' from the left-hand menu.
Click the 'Create PDF/XPS Document' button.
Choose your save location, ensure 'Standard (publishing online and printing)' is selected for optimal quality, and click 'Publish'. Test the resulting PDF to confirm the links open as local files.
Batch-Correct Links in Acrobat Pro
If you must use PDFMaker and the links are converted incorrectly, you can manually fix the link properties or use a script in Adobe Acrobat Pro to change them back to file links.
Convert Excel to PDF with Intact File Links Using WPS Office
WPS Office Spreadsheet includes a powerful, built-in PDF converter that seamlessly exports documents of any length while preserving your original hyperlink paths and file references without the bugs associated with third-party plugins.
- 1. Open your Spreadsheet: Launch WPS Office and open the spreadsheet containing your local file links.
- 2. Select Export to PDF: Click the 'Menu' button at the top left corner of the application interface, and select 'Export to PDF' from the dropdown list.
- 3. Configure Export Settings: In the export dialog box, verify that your export range (e.g., Entire Workbook or Active Sheet) is correctly set to include all necessary pages.
- 4. Export and Verify: Click 'Export to PDF', choose your desired save destination, and click 'Save'. Open the newly generated PDF to verify that your file links are working as intended.
Frequently Asked Questions
Why do local Excel file links change to web browser links in my PDF?
This behavior is typically caused by a known glitch in the Adobe Acrobat PDFMaker add-in when handling Excel worksheets that span across multiple printed pages. The pagination process disrupts the add-in's ability to properly map the link attributes, causing it to default to a web URL format.
How do I check if my Excel hyperlink is configured correctly before exporting?
Right-click the cell containing the hyperlink and select 'Edit Hyperlink'. Look at the 'Address' field at the bottom. Verify that it points to a local drive letter (e.g., C:\folder\file.pdf) or a network path (e.g., \\Server\folder) rather than starting with 'http://' or 'https://'.
Does updating Adobe Acrobat fix the PDFMaker link issue?
Sometimes. Adobe periodically releases patches that address how PDFMaker interacts with Microsoft Office. It is highly recommended to check for updates in Acrobat by going to Help > Check for Updates, and testing the conversion again.
