Skip navigation
AuntDi3
AuntDi3
Currently Being Moderated

Convert with Page Breaks

Feb 20, 2012 6:11 AM

Categories: Windows

I have a workbook in Excel that I am trying to convert to PDF (I have Adobe Professional 9.0).  On two of the worksheets in this workbook I have inserted page breaks.  However, when I convert the workbook, the page breaks to do not cross over to pdf.  Instead, some of my charts are cut in half.  How can I get the page breaks included in the conversion of the workbook?  I don't want to set it to fit each worksheet to a page, because two of the worksheets (the two with page breaks) have eight charts on them and if they are confined to one page, they are too small to read.  Any assistance you can provide would be greatly appreciated.

541 Views   5 Replies   Latest reply: Bill@VT, Feb 21, 2012 6:52 AM
 
Replies
  • Bill@VT
    Currently Being Moderated
    1. Bill@VT,
    Feb 20, 2012 11:22 AM   in reply to AuntDi3
    Report

    First, open Excel and select the Adobe PDF printer in the printers menu (don't print). Then go through your document and check the page breaks (they are probably all messed up). Fix the breaks and try creating the PDF again. I suspect you are running into printer metric issues with Excel. It would help to know what version of Excel you are using.

     
    |
    Mark as:
  • AuntDi3
    Currently Being Moderated
    2. AuntDi3,
    Feb 20, 2012 11:37 AM   in reply to Bill@VT
    Report

    When I just Print to Adobe, my page breaks cross perfectly.  However, I have hyperlinks that I want to keep, so I was using the “Create PDF” button from the Adobe add-in in Excel.  When I use that button, the hyperlinks cross, but the page breaks don’t.

     

    I am using Excel 2010.

     

    Thank you,

    Diane Royer | Product Support Analyst

     
    |
    Mark as:
  • Bill@VT
    Currently Being Moderated
    3. Bill@VT,
    Feb 20, 2012 5:49 PM   in reply to AuntDi3
    Report

    I was not suggesting to print to the Adobe PDF printer, but select that printer to be sure that the printer metrics are properly used by Excel to setup the document. It may be that Excel is using the printer info in setting up the file and that can be the issue with the create PDF option. The attaching the Adobe PDF printer was to set up Excel with the PDF printer metrics, if that option is turned on in Excel.

     
    |
    Mark as:
  • AuntDi3
    Currently Being Moderated
    4. AuntDi3,
    Feb 21, 2012 5:27 AM   in reply to Bill@VT
    Report

    How can I tell if Excel is using the printer info in setting up the file?  How do I check the printer metrics?  I set the printer to the pdf writer and then clicked on Preview.  The page breaks all appear to be correct in this view.

     
    |
    Mark as:
  • Bill@VT
    Currently Being Moderated
    5. Bill@VT,
    Feb 21, 2012 6:52 AM   in reply to AuntDi3
    Report

    PDF writer is from the days of AA5, it should be the Adobe PDF printer. If that is what you meant and the Preview checked out, then that would normally indicate you are fine. With OFFICE 2007, MS started turning off use of metrics by default, at least in WORD. They are set way down in an options list, typically related to compatibility. If you could sanitize your Excel sheet and the problem PDF, then post them someplace (infortunately posting was removed from the Adobe forums for security), folks would then be able to test your setup. Also, what version of Windows are you using (or is it an Apple machine) and if it is a 64-bit system, are you running the 64-bit office? All of this information helps focus on the problem.

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points