Fix Excel Worksheets Becoming Hidden After PDF Export
Question details
Users experience an issue where Excel worksheets unexpectedly become hidden after exporting selected sheets to a PDF file.
- Product
- Microsoft Excel, Adobe Acrobat PDFMaker
- Device & OS
- not provided
- Scenario
- Exporting specific Excel worksheets to a PDF format using the Acrobat add-in.
- Observed behavior
- The Acrobat PDFMaker add-in inadvertently modifies the workbook's visibility settings during the conversion process, causing unselected worksheet tabs to become hidden.
Before proceeding with any export process or add-in adjustments, make a copy of your Excel workbook so you can easily restore your original worksheet visibility if needed.
Use Excel's Built-in PDF Export Feature
Bypassing the Acrobat PDFMaker add-in and using Excel's native export options prevents third-party tools from altering your sheet visibility.
Microsoft Excel includes a robust, built-in PDF converter that does not interfere with the visibility settings of your workbook tabs. Using this native feature is the most reliable way to avoid the Acrobat add-in bug.
Open your Excel workbook and highlight the specific worksheets you want to export by holding down the Ctrl key and clicking the desired tabs.
Click on the 'File' tab in the top-left corner of the Excel ribbon, then select 'Export' from the left-hand navigation menu.
Click the 'Create PDF/XPS Document' button. In the window that appears, click 'Options' to verify that only 'Active sheet(s)' is selected, then click 'Publish' to save your file.
Restore Visibility of Hidden Worksheets Manually
If your worksheets have already become hidden after a previous export, you can restore them using Excel's unhide functionality.
Update Microsoft Office and Adobe Acrobat
Software bugs causing worksheet visibility issues are often patched in newer versions. Keeping both applications updated can resolve add-in conflicts.
Export Spreadsheets to PDF Seamlessly with WPS Office
Tired of add-in conflicts and hidden worksheets in Microsoft Excel? WPS Office provides a free, lightweight alternative with a highly compatible Spreadsheet tool. Its built-in PDF converter allows you to export specific sheets flawlessly without altering your workbook's layout or visibility.
- 1. Download WPS Office: Download and install WPS Office for free from the official website.
- 2. Open your workbook: Open your existing Excel workbook (.xlsx) directly in WPS Spreadsheet.
- 3. Export to PDF: Go to the 'Menu' in the top-left corner and select 'Export to PDF'.
- 4. Save the file: Choose your export range and click 'Export' for a flawless conversion without hidden tabs.
Frequently Asked Questions
Why does the Acrobat PDFMaker add-in hide my Excel tabs during export?
The PDFMaker add-in temporarily modifies the workbook's background visibility settings while rendering the selected sheets. Due to a known software conflict between certain versions of Office and Acrobat, it fails to revert these settings once the export finishes, leaving the unselected tabs hidden.
How can I disable the Acrobat PDFMaker add-in in Excel?
Go to File > Options > Add-ins. At the bottom of the window, ensure the 'Manage' dropdown is set to 'COM Add-ins' and click 'Go'. Uncheck the box next to 'Acrobat PDFMaker Office COM Addin' and click OK to completely disable it.
Does using Excel's native 'Save As PDF' reduce the output quality?
No, Excel's native PDF export offers high-quality output suitable for standard business documents. By selecting 'Standard (publishing online and printing)' in the options dialog before saving, you ensure optimal resolution without relying on third-party add-ins.
Is there a way to unhide all worksheets at once in Excel?
In Microsoft 365 and newer versions of Excel, you can right-click a sheet tab, select 'Unhide', and hold down the Ctrl or Shift key to select multiple hidden sheets to unhide simultaneously. In older versions, you can only unhide one sheet at a time manually or use a VBA macro.
