A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
We are experiencing the exact same issue and have formally reported it to Microsoft.
In our case, several Excel workbooks contain VBA macros that generate PDF reports using Worksheet.ExportAsFixedFormat. These files have been used successfully for a long time and were working normally until approximately November 10, 2026.
Starting on November 11, 2026, a few users began reporting PDF export failures. Within days, the issue spread to additional users and machines without any changes to the VBA code itself.
After troubleshooting, we found that the problem is directly related to Conditional Formatting Icon Sets (traffic-light indicators). When icon-set conditional formatting is present, PDF generation either fails or produces incorrect output. If we remove the icon-set formatting or replace it with a different visual indicator such as cell fill colors, PDF export works normally again.
We tested multiple workbooks and different export macros. Although the VBA implementations vary, all affected solutions rely on ExportAsFixedFormat, and all exhibit the same behavior when icon-set conditional formatting is used.
Because these files worked correctly before and the issue appeared suddenly across multiple users, this appears to be a regression introduced by a recent Excel update, likely affecting the PDF rendering/export engine.
I have submitted a detailed report to Microsoft and wanted to add our findings here in case they help identify the root cause.
Is anyone aware of a fix, workaround, or specific Office build where this issue was introduced? We strongly believe it is important to keep using the macro rather than relying on manual printing, because for most of our worksheets these VBA routines automatically identify the required sheets and consolidate multiple print jobs into a single PDF export.
Macro 01 (part of total code)
For Each ws In ActiveWindow.SelectedSheets
With ws.PageSetup
.Zoom = False
.FitToPagesWide = 1
.FitToPagesTall = 1
.Orientation = xlLandscape '
End With
Next ws
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
ActiveWorkbook.Path & "\" & "Status Report Medicamento G5 2026 - " & Format(Date, "dd-mm-yyyy") & ".pdf" _
, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
:=False, OpenAfterPublish:=True
Planilha22.Select
Macro 02 (part of total code)
.Orientation = xlLandscape
.Zoom = False
.FitToPagesWide = 1
.FitToPagesTall = False
.LeftMargin = Application.CentimetersToPoints(0.5)
.RightMargin = Application.CentimetersToPoints(0.5)
.TopMargin = Application.CentimetersToPoints(0.5)
.BottomMargin = Application.CentimetersToPoints(0.5)
.CenterHorizontally = True
End With
CaminhoPDF = Environ("USERPROFILE") & "\Downloads\Status Report_" & _
Format(Date, "dd-mm-yyyy") & ".pdf"
ws.ExportAsFixedFormat _
Type:=xlTypePDF, _
Filename:=CaminhoPDF, _
Quality:=xlQualityStandard, _
IgnorePrintAreas:=False, _
OpenAfterPublish:=True