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.
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.
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.
Diane Royer | Product Support Analyst
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.
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.
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.
Europe, Middle East and Africa