A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Hi Daniel,
Welcome to the Microsoft Q&A forum.
Thank you for providing the detailed information.
Based on your test results, the issue appears to be related to how Excel’s built-in PDF export engine renders conditional formatting Icon Sets. This is indicated by the fact that the dashboard displays correctly in Excel and Print Preview and is also exported successfully when using Microsoft Print to PDF. However, both Create PDF/XPS and the VBA ExportAsFixedFormat method produce a blank dashboard page.
To help determine whether the issue is specific to the current workbook or related to Excel’s built-in PDF rendering mechanism, please perform the following test:
- Create a completely new Excel workbook.
- Enter some sample values, such as 10, 20, 30, and so on up to 100, in cells A1:A10.
- Select these cells, then go to Home > Conditional Formatting > Icon Sets > 3 Arrows.
- Set a Print Area that includes these cells.
- Check whether the worksheet is displayed correctly in Print Preview.
- Export the worksheet by going to File > Export > Create PDF/XPS, then check whether the content is displayed correctly in the PDF file.
If the same issue also occurs in the new workbook, please try removing the Icon Set or replacing it with another type of conditional formatting, such as Data Bars or Color Scales. Then, export the PDF again and let me know the result.
I look forward to your response.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.