Answers
Short answer: No Excel-to-PDF converter merges separate workbooks into one PDF, because merging is a PDF operation rather than a conversion one. You have two honest routes. Convert each workbook to PDF, then join the PDFs with a merge tool. Or restructure the pack upstream as a single multi-sheet workbook, which renders to one PDF with each sheet as its own section in a single pass. The second route is better whenever the pack is produced on a repeating cadence.
This is the right route when the source files genuinely belong to different people or systems and cannot be consolidated.
If you control the source, make the deliverable a single workbook with one sheet per section — cover, summary, then each schedule. Export the entire workbook and you get one PDF, in sheet order, with no merge step and no page-size mismatch.
This is what a board pack, a budget pack or a month-end close pack actually wants to be. It also makes the next period cheaper: the structure is the template, and the export is one action rather than twelve plus a merge.
Be clear about the limit before you plan around it. CrazySmartPDF renders one PDF per workbook, with every sheet laid out as its own section, and the desktop app takes a whole folder in one pass. It does not merge a folder of workbooks into a single combined PDF — if that is the deliverable, you still need a merge step, or route 2.
What it does add on route 2 is the part that usually goes wrong in a multi-sheet pack: rows stay whole across page breaks, a wide schedule is resized to a readable floor or sliced across pages with the label column repeated rather than clipped, cover and pivot sheets export through your installed Excel so they keep the workbook’s real styling, and every rendered file is scanned for blank or clipped pages with the suspects flagged for review. It flags them; it does not rewrite your workbook. Windows with Excel 2016+, free on your own files. See how it works, or read how to decide between one pack and many files.
Can Excel combine several workbooks into one PDF? No. Save as PDF works on one workbook — active sheet, selected sheets, or the entire workbook. Combining separate files is a PDF merge, done after conversion.
Is it better to merge PDFs or to build one workbook? Build one workbook when you own the source and the pack repeats: it removes the merge step and keeps the page setup consistent. Merge when the files come from elsewhere.
How do I keep page numbers continuous across a merged pack? Number the pack after merging, in a PDF tool. Excel numbers each workbook’s pages independently, so per-file numbering restarts at every seam.
What if the merged PDF has mixed page sizes and orientations? Set the paper size and orientation identically in every source workbook before converting. A merge tool will not normalise them, and a pack that flips between portrait and landscape reads as an accident.
