+ Reply to Thread
Results 1 to 4 of 4

Printing Entire Workbook to a Single PDF File

  1. #1
    Registered User
    Join Date
    08-07-2012
    Location
    Springfield, IL
    MS-Off Ver
    2007
    Posts
    8

    Printing Entire Workbook to a Single PDF File

    I have a workbook with about 30 tabs that prints to 41 pages when printing the entire workbook. These are financial statements. It prints fine on a printer. However, I want to print the entire workbook to a PDF file. During this process, it will stop 3 times, always after the same pages, and ask for a new file name. So I get 3 PDF files instead of one. I cannot figure out how to get everything to print to one file. There is something in the formatting that is causing it to stop and ask for a new file name. I have tried this with 4 different PDF printing programs including a fully licensed version of Adobe Acrobat. It is definitely an Excel issue. I am running Excel 2013.

    Chris

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Printing Entire Workbook to a Single PDF File

    maybe this
    http://www.novapdf.com/kb/printing-a...-file-135.html
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Registered User
    Join Date
    08-07-2012
    Location
    Springfield, IL
    MS-Off Ver
    2007
    Posts
    8

    Re: Printing Entire Workbook to a Single PDF File

    Thanks for the tip but all my sheets have the same DPI setting. This is actually one of the 4 PDF programs I tried. Still looking for a solution.

  4. #4
    Registered User
    Join Date
    08-07-2012
    Location
    Springfield, IL
    MS-Off Ver
    2007
    Posts
    8

    Re: Printing Entire Workbook to a Single PDF File

    Actually, that did solve my problem. I had 3 (out of 30) sheets where the DPI setting was blank. Have no idea why. Thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Printing Entire Workbook with VBA pages
    By Caedmonball19 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-15-2012, 12:36 PM
  2. Printing an entire workbook in duplex form?
    By 1940LaSalle in forum Excel General
    Replies: 1
    Last Post: 05-19-2011, 10:59 AM
  3. [SOLVED] Why does my print job split up when printing the entire workbook?
    By BethRDSuser in forum Excel General
    Replies: 0
    Last Post: 06-05-2006, 03:10 PM
  4. [SOLVED] printing entire workbook
    By loralei in forum Excel General
    Replies: 1
    Last Post: 03-09-2006, 07:40 PM
  5. [SOLVED] Printing an entire workbook
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-06-2005, 06:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1