excel convert to pdf problem

Posted on 2011-05-11
Last Modified: 2012-05-11
when a new work sheet is added to a multi worksheet document and you then ask it to print to pdf or xps it will stop at that sheet and then you have to convert the new sheet and then carry on to do the rest.
If you copy a sheet and then delete its contents it will convert the whole file with no problems
any idea why you cant just add a new sheet and convert to pdf
Question by:roger190667
    LVL 2

    Accepted Solution

    You can verify in the Layout tab that the new sheet has the same properties like size, margin...
    If something is different, it can cause this problem.
    LVL 6

    Expert Comment

    by:Eric Zwiekhorst
    Hi Roger,

    I tried this with a 11 sheets workbook, I added a new one, changed the tab name an printed all at once on the PDFcreator printer.
    Out came a pdf including the new tab?

    Can't reproduce, can you tell me wich PDF convertor you are using?



    Author Comment

    Hi Zwiekhorst

    I am using acrobat adobe writer 9 but also happens if i use mirosoft xps document writer



    Author Closing Comment

    This turned out to be in the page layout and the dpi settings.
    on further investigations it seems that when excel finds a sheet with different  dpi settings it sees it as a seperate print job

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
    Many companies are making the switch from Microsoft to Google Apps ( Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
    The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
    This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now