Microsoft® Excel® for Microsoft 365 MSO (Version 2201 Build 16.0.14827.20180) 32-bit
I have a sheet that is amended regularly and published using the "Print to PDF" option. If I modify the sheet in any way then try to Print to PDF I can select the option but it immediately reverts to my default printer. If I save the document, close Excel and then re-open it I can Print to PDF or any other printer.
This problem is not restricted to just one file or even one computer as I have the same issue with any Excel spreadsheet on either my PC or a laptop.