Highlighted

Create one pdf from multiple Excel tabs within a single spredsheet

New Here ,
Jan 30, 2018

Copy link to clipboard

Copied

My office recently applied an update to Acrobat XI Pro (we now are on 11.0.23). Prior to the update, in both Excel 2013 and 2016, when we printed to "Adobe PDF" the entire workbook (all tabs or multiple selected tabs), it would put all of the output into one PDF file. Now it is splitting them up by what appears to be page size. What do I do to change it so that the output is all in one PDF file?

Thanks!

Jay W. Ahearn  PMP,  PMI-ACP, MCP

TOPICS
Create PDFs, Windows

Views

23.5K

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

Create one pdf from multiple Excel tabs within a single spredsheet

New Here ,
Jan 30, 2018

Copy link to clipboard

Copied

My office recently applied an update to Acrobat XI Pro (we now are on 11.0.23). Prior to the update, in both Excel 2013 and 2016, when we printed to "Adobe PDF" the entire workbook (all tabs or multiple selected tabs), it would put all of the output into one PDF file. Now it is splitting them up by what appears to be page size. What do I do to change it so that the output is all in one PDF file?

Thanks!

Jay W. Ahearn  PMP,  PMI-ACP, MCP

TOPICS
Create PDFs, Windows

Views

23.5K

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Jan 30, 2018 0
Guide ,
Jan 31, 2018

Copy link to clipboard

Copied

If you are using printing to Adobe PDF virtual printer, check the print settings, it could very well be that your print settings have reverted back to their default. There is a Fit Sheet on One Page scaling option you can select.

fit-worksheet-to-page-2.png

You can also create PDFs from the Acrobat ribbon in Excel, if prior to clicking on Create PDF, you click Preference, you can enable a similar setting: Fit Worksheet to a single page. If you leave the Prompt for conversion settings option selected, you can always adjust the settings as you create the PDF as well.
fit-worksheet-to-page.png

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jan 31, 2018 1
New Here ,
Jan 31, 2018

Copy link to clipboard

Copied

Cari,

Thanks for your response! Unfortunately none of those options worked. I am trying to print a multi tabbed workbook that uses different page setups on each tab (e.g. one tab is set to print on letter and the next is set to print on legal). Before the update, when I printed the entire workbook, it would create one PDF with different page sizes within the single PDF.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jan 31, 2018 0
Guide ,
Jan 31, 2018

Copy link to clipboard

Copied

Aaah got it.  A bit different from what I understood originally. You should still be able to do this AND have different page sizes set-up for each worksheet. I've just tested it and got it working.

  1. For each worksheet in Excel, in the Page Layout toolbar, ensure Width and Height are set to 1-page, also check for each worksheet that the Size is set as intended (also in the Page Layout toolbar).
    fit-worksheet-to-page-3.png
  2. And in the Print dialog, click on Page Setup (just below Fit Sheet on One Page), and ensure that the Page setting is set to Fit to 1 pages wide by 1 page tall (it should automatically be set correctly).  If you toggle through the Preview to navigate to other worksheet print previews and access the Page Setup agin, you should also be able to notice that when you check the Page Setup the Paper Size will adjust as per the settings applied to each worksheet (from the Page Layout toolbar in Excel).
    fit-worksheet-to-page-4.png

I just tested this with two different worksheets and it worked OK.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jan 31, 2018 0
New Here ,
Jan 31, 2018

Copy link to clipboard

Copied

Cari,

Unfortunately that doesn't work as some of the tabs when printed are multiple pages each and alternate between landscape and portrait as well as letter and legal.

Thanks!
Jay

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jan 31, 2018 0
Guide ,
Feb 07, 2018

Copy link to clipboard

Copied

Hmm... that is strange, as I can set different page size, orientation, and single or multiple page within Excel Page Layout tool bar for each sheet, it all works as you need it to work... I can't replicate the issue you are having.

See below screenshots:

Sheet 1 = set up as 100% magnification, Paper Size: Letter, Orientation: Portrait

Sheet 2 = set up to fit 1 page by 1 page, Paper Size: A3, Orientation: Landscape

Sheet 3 = set up to fit 1 page by 1 page, Paper Size: Tabloid, Orientation: Portrait

The Print Preview clearly shows this will work as intended.

Just to clarify I'm testing in:

  • Microsoft Excel Version 1712 (Build 8827.2148)
  • Adobe Acrobat DC Pro (Continuous Release | Version 2018.009.20050)
  • Windows 10 Pro

Preview Screenshots for Sheet 1 (page 1 and 2), Sheet 2 (page 3), and Sheet 3 (page 4):

preview-page1.png

preview-page2.png

preview-page3.png

preview-page4.png

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Feb 07, 2018 0
New Here ,
Feb 08, 2018

Copy link to clipboard

Copied

Sorry I really should have clarified. When I do the print preview, It shows up as one file with many different pages of different sizes and orientation as it use to. It is when you actually create the PDF it prompts me to create new PDF files for each of the different page sizes/orientations which end up containing only the pages that are different.

My environment:

Windows 10 (64 bit)

Excel

     2013 - 15.0.4997.1000 (32 bit)

     2016 - 16.30.4591.1000 (32 bit)

Adobe Acrobat Pro XI version 11.0.23

Thanks for your patience and assistance!

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Feb 08, 2018 0
New Here ,
Jan 15, 2020

Copy link to clipboard

Copied

Jayson2204, Did you ever receive a solution?  This is exactly what is happening to us in our office.  Use to work just fine, but about two months ago it stopped and created a separate PDF for each sheet tab.

My environment:

Windows 10 Pro

64-bit operating system

Excel - Microsoft Office 365 ProPlus (Version 1902)

Adobe Acrobat Pro DC Version 2019.021.20061

 

Thank you for any solutions you can share.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jan 15, 2020 1
New Here ,
Feb 28, 2020

Copy link to clipboard

Copied

This is also happening to us!

 

No it doesn't seem anyone ever received a further response from Adobe on how to resolve this issue. Surley this is a really obvious peice of functionailty? You  need to be able to print PDF docs from miultiple sheets in Excel all with (potentially) different page sizes. To have to print them all out separatley and then merge them all together into one PDF afterwards is such an unnecessary repetitive faff in the year 2020 - please sort it out!

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Feb 28, 2020 1
New Here ,
Mar 02, 2020

Copy link to clipboard

Copied

The issue might be with Microsoft. I have encountered the same issue. Microsoft Print to PDF behaves in the same way.

My environment:

Windows 10 Education

64 Bit Operating System

Excel Microsoft Office 365 Pro Plus (Version 2002)

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Mar 02, 2020 0
New Here ,
Mar 18, 2020

Copy link to clipboard

Copied

Seems like if the DPI is changed to be the same, everything will print in one PDF file. Go to Page Setup and then change print quality to be the same for all of the tabs. This might change the printing parameters a little, but it should do the trick!

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Mar 18, 2020 0
New Here ,
Jun 21, 2020

Copy link to clipboard

Copied

I had the same problem - printing multiple tabs to PDF being split up - was going mad. Changing to the same DPI (600 dpi) in the page layout menu on each tab resolved the issue.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jun 21, 2020 1
New Here ,
Sep 05, 2020

Copy link to clipboard

Copied

This actually resolved mine too!

Thanks. you should try this solution also.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Sep 05, 2020 0