The Excel document I am trying to convert is only 184kb. I also tried doing a test Excel that was smaller with three sheets and it created the pdf but it put it all into one three separate pages in Adobe. I am not sure if I am following what you mean about selecting the print area? When I print to a pdf I select the who Workbook.
For some reason I recall that having separate tabs in Adobe is possible.
I don't see where I have said that.
I am not having any issues creating a pdf from Excel. All I am saying is I would like to see the tabs from Excel or some type of separate sheet broken out in Adobe instead of a continuous 330 page document.
Look at the attachment, the first part is an example of Excel with the three tabs, the other is that same Excel created into a pdf. If you see it takes the three tabs and makes them separate pages in Adobe. I don't want it to do that, I want to have some type of tab like Excel.
Understand a little better?
First of all the video shows a program called "Classic PDF Editor", I am almost positive that is not approved nor used in the Government. Second is I am not having difficulties creating a PDF from Excel, I just need to see some type of separation of different worksheets from Excel.
I feel like a broken record, I do know without pictures it may be hard to explain it.
Once content is in PDF there is no such thing as "workbook" or "worksheet". PDF is content painted to a "page".
As dictated by the quantity of content there may be many pages.
PDFMaker can be configured to prompt for which worksheets of a workbook, in Excel, that are to be processed out to PDF.
With multiple worksheets selected each worksheet's content is processed out, in sequence, to the PDF being created.
So, the first worksheet's content fills PDF page 1 through page N. The second worksheet's content fills PDF page N+1 through page M.
This continues for all selected worksheets.
The result is, as expected, a multi-page PDF.
If the PDFMaker has been configured to create PDF Bookmarks then a Bookmark is created for each worksheet.
The Bookmark's label will reflect the worksheet's "name" in its respective tab back in Excel.
The Bookmarks' default action will be:
Go to a page in this document (e.g., the PDF)
---| Page: "n" (the page on which the worksheet's content starts)
---| Zoom level: Inherit Zoom
Clicking on any given Bookmark takes the user to the start page of the Bookmark identified worksheet content.
. Some screen captures that may help.
PDFMaker's configuration dialog
If "Prompt for Selecting Excel Sheets" is ticked in the PDFMaker configuration dialog then this dialog appears when PDFMaker begins the PDF creation process.
The output PDF will have a Bookmark that permits navigating to the start of content for the designated worksheet content within the PDF.
To view the Bookmarks the Navigation Pane must display.
For any PDF, if one configures the PDF's Document Properties > Initial View tab both the PDF page and the PDF's Bookmarks pane can be set to show upon opening of the PDF.
For many PDF's Acrobat Pro can be used to establish this with the "Open" sequence via a Batch Sequence / Action.