Incorrect page size when creating PDF from Excel 2013 (export and print)

[mtthwmrrsn]

I am in the USA so everything tends to default to 8½"x11" ... but I created a document in Excel with A size settings. I have attempted to export it to PDF with every setting I can find set to A4 and I have attempted to print the document to PDF again with every setting I can find set to A4 (page size, layout - advanced - paper/output - paper size - A4) with all scaling turned off and yet when I open the finished document in Acrobat XI Pro (with all updates installed) the document properties lists it as 8½"x11". I don't see any resize document settings in Acrobat or any other reason it would be anything but A4 in Acrobat's settings, and I've even had someone in our design department that uses Acrobat extensively look at my steps and they don't see where I'm making any mistakes.

Does anyone here have any suggestions?

[Phillip M Jones]

Try  as shown her to see what happens:

Before you say there goes that Mac fellow again.  Yes I do use a Mac, and the layout of this window may look different in PC. But; the same controls and items, should be there. Even though they may be labelled slightly different.

[mtthwmrrsn]

No worries, I use both Mac and PC. Unfortunately this did not help. It still says the document size is 8.5x11. I think my problem is in the conversion somewhere... even though the source is A4 and the page size says A4 in the Adobe print options, it is generating a 8.5x11 document. There must be one simple step or tick box I am overlooking somewhere when I do the print/export from excel.

[Phillip M Jones]

Notice in the illustration the button Page setup.

Click on that and see if you can set printer from there.

I don't know whether this is in the PC version.

This is an adobe dumb idea inserting a Print menu in between a print menu and the printer, and not allowing the Printer to do the control Setup itself.

One of them ideas that came up when a developer was sitting around twidling his thumbs, and saying hey lets do this.  Another idea That comes along with this, is the inserted property feature called simplex printing. If you want to print a PDF duplex you can setin printer till cows come home and you blue in the face. Won't print Duplex.  You have to Click Propties and Locate the command simplex, and turn off.

[mtthwmrrsn]

If I go to page setup and set it to A4 then I just get extra white space above and below the document. If I go into the printer properties in the excel  print cue and look at the default settings (standard) preferences it is set to a default page size of 8.5x11. The odd thing is that I do not see any place to select a paper size in these settings, only a place to put in actual size dimensions. But if I create a custom  default setting and put in the actual dimensions of an A4 document and print then my final PDF is still 8.5x11. I can't find any other place to solve my problem.

The odd thing is that if I go into excel and hit save as and select PDF I get a document that is 9.24x11.96... which completely confuses me.

[mtthwmrrsn]

Well I ended up doing the Save As in Excel, taking the larger document into Acrobat and then printing that to A4 as a work around. I'm still not sure why I just couldn't export.

Thanks for the assistance.

[Bill12]

On the PC, you often have to open the printer properties and change the page size to A-4. I would have thought that the Actual Size would have done it, but it may also be that the Excel is in Letter format.

[heatherg89029660]

I was having similar issues - a document I had received (not but made) was coming up with a printer error saying that I needed to load paper that was 8.5 x 11 inches. It was an A4 document and the print setup was for an A4 page.

I fixed this by opening the 'advanced paper selection' settings in the print properties and ensuring that 'output paper size' was set to A4. This had been set at 8.5 x 11 inches for some reason.

[paavoi20635534]

Hi, it's actually a setting in Excel.

Options - Advanced - Scroll down to General - "Scale content for A4 or 8.5 x 11 paper sizes"

Unselect that and it should work!

Paavo

[davidk6602983]

I have the same issue. Using the excel VBA code of

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=FileName1, OpenAfterPublish:=True

In Excel when I do a normal File>Print action the document comes out as Letter size as my settings indicate, but when I use the VBA code the resulting document comes out in Legal size.  I am using Excel Office Pro Plus 2010.  I was tying to automate the production of a weekly review document that pulls data from several excel documents.  Those are each printed as PDFs then assembled into a single document.  Tis would be a lot easier if there where VBA commands that could combine several PDF documents into one.