When I came across this post on AcrobatUsers.com the other day, I thought this would be a straightforward task.
I have an Excel workbook (excel 2007) with multiple worksheets and want to convert each worksheet to a separate pdf file.
In the end it wasn’t exactly straightforward, but there is a convenient workaround.
I found the easiest way to do this is to create a PDF of the entire workbook (with bookmarks) from Excel, and then split the PDF into individual files in Acrobat. So to start, click on the Preferences icon under the Acrobat Ribbon in Excel and make sure the Create Bookmarks box is checked.
Next, select Create PDF from the Acrobat Ribbon in Excel and choose Entire Workbook from the PDFMaker dialog.
When you open the PDF file in Acrobat, you’ll see top-level bookmarks for each worksheet listed in the Bookmarks navigation pane.
Next, open the Tools pane > Pages panel and select the Split Document command. In the dialog, select the Top-level bookmarks radio button and this will break apart each worksheet into individual PDF files.
If you have several PDF files that you need to break apart using this technique, click the Apply to Multiple button in the above dialog. This will bring up the Split Documents dialog where you can add files and folders of PDF files to convert to individual PDF files using the top-level bookmarks in each file.