We've run into this exact same issue. Acrobat 9, Excel 2007, XP SP3.
We were able to isolate it to uses who had their currently selected printers set to either Dell Color Lasers 51xx or Xerox Phaser 6200 Color Lasers (very similar printers). When they changed to an HP LaserJet (or the AdobePDF printer) selected as the current printer, the problem did not occur.
Somehow it seems that the PDF maker isn't getting the correct paper size from the printer driver in all cases. Not sure if this is an issue with Excel, Acrobat or the print driver. Haven't been able to find a fix, but can at least work around it.
This is probably related to a known issue in Excel 2007. Additional detail can be found in the MS knowledgebase article "When you save an Excel 2007 workbook as a PDF file or as an XPS file, the layout differs from the layout in the Excel 2007 workbook".
The workaround is to configure the dpi settings in Excel 2007 to match the dpi settings of the PDF file.
- In Excel 2007 select the Page Layout tab.
- Under Page Setup, click the Page Setup dialog box.
- In Print Quality select 600 dpi for standard output.
The work-around is not working in my case.
I changed the Print Quality setting to 600 dpi, and I confirmed that the PDF setting for PDFMaker was 600 dpi, too.
The page size of the resultant PDF is still the weird 11.19 x 14.47.
It is correct (8.5 x 11.0) when I use the Print function to print with the Acrobat PDF printer.
I note that the MS article is explicitly directed at the SAVE AS functionality inside of Excel, rather than a add-in, such as PDFMaker.
Also, by the way, I insured that the Adobe PDF printer was selected as the current printer.
This is a most annoying, and fascinating problem!
Has either work-around avoided the problem for anyone else?
There is an Adobe Technical note on this as well so it's not just a Save As issue:
If you don't use any fancy Excel 2007 features, you can try saving back to 2003 to see if can print correctly.
Has anyone come up with another solution for this issue as it is happening to me after following the recommended instructions (dpi resetting)? I have another computer using 2003 Excel, but I'd rather use something current, if possible.
I have the same problem. Printing works fine if I use the adobe printer. Only, I have to save multiple files when printing entire workb
ook, which doesn't make any sense. I'd like the solution, too!!!
We were able to work around this issue in the case where it was a Dell laser printer driver by diabling the "Apply Zoom To Application" setting in the advanced printer settings. Somehow the print driver zoom was interfering with the page scaling in Excel to send the wrong paper size to the PDF maker. While this only works if the driver allows that feature to be turned off (our Xerox Phaser doesn't), at least it's something. I'm not sure why the printer settings for the currently selected printer would be interfering with the PDF maker output, but it does.
It's been long since this topic was active but I just wanted to share my solution to a similar problem.
I was trying to use the built-in Save as PDF function of Excel 2007 and my sheet which also had some headers and footers was not coming out correctly.
From Page Layout tab, I clicked the small icon on the corner of the Page Setup. Then I clicked the Header/Footer tab and removed the tick next to where it says "Scale with document" and viola! I miraculously could export my sheet in the correct page size.
May this be helpful to not just who have had this problem before, but also the ones that will come afterwards!
Yes, this was a big help, Thanks