Answers
Short answer: For an export you repeat every period, there are four rungs on the ladder, and most people are one rung lower than they need to be. Save the page setup into the template so you stop redoing it. Record a VBA macro if you want a button inside the workbook. Build a Power Automate flow if the files already live in OneDrive or SharePoint and the trigger should be an event rather than a person. Or hand the whole folder to a desktop batch tool that renders every workbook in one pass, lays out each sheet properly, and writes a log of what it produced. The right rung depends on whether your problem is the clicking or the layout.
Before automating anything, put the page setup into the template rather than into your habit. Orientation, scale-to-fit width, print titles for the header row, margins — set them once, save the file as a template, and every period’s copy inherits them. This is unglamorous and it removes more repeated work than most macros do.
A short macro looping the worksheets and calling ExportAsFixedFormat turns the run into one click. It is free, it lives with the file, and anyone who has recorded a macro can maintain it — until they leave. The honest limits: it exports exactly what Excel’s own export produces, so the split rows and clipped columns come along, and it breaks quietly when someone renames a sheet.
If the workbooks already sit in OneDrive for Business or SharePoint, the “Convert file” action turns them into PDFs inside a flow, on a schedule or on a trigger. It genuinely removes the person from the loop. It also renders each file as-is, server-side, and needs the right Microsoft 365 plan. Worth it when the trigger matters more than the layout — see the full comparison.
The other shape of the problem is not the trigger at all. It is that every period you open twenty workbooks, fix the page setup on each, export, then open the PDFs to check nothing came out clipped. A desktop batch tool takes the folder in one pass: it re-lays-out each sheet so rows stay whole and wide tables stay readable, renders the sheet’s full data range rather than only what an old print area covers, writes a run log so you can see every file was produced, and flags any page that came out blank or clipped for you to look at. It flags them — it does not rewrite your workbook.
CrazySmartPDF does this on Windows with Excel 2016+, free for runs of up to five files. It is not a scheduler: a person still starts the run, and in batch mode there is no per-file notice about data that sat beyond a print area. What it removes is the per-file busywork and the manual check afterwards. See how it works.
Can I schedule an Excel-to-PDF conversion to run overnight? With Power Automate or a scripted command-line converter, yes — both are built for unattended runs. A desktop batch app is started by a person, so it is not the tool for a 2am job; it is the tool for a run you do want to watch finish.
Does automating the export fix split rows and cut-off columns? No. Automation repeats a result faster. If the export is broken, the automated one is broken too, on schedule. The layout has to be re-computed, which is a different step from triggering the export.
What is the fastest way to make a monthly reporting run stop taking an evening? Put the page setup in the template, then convert the whole folder in one pass instead of file by file, and let the tool check its own output rather than opening every PDF yourself.
