Participant

Question

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

Forum|Forum|12 years ago
September 29, 2013
4 replies
45258 views

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?

D

davidk6602983

Participant

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.

paavoi20635534

Participant

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

H

heatherg89029660

Participant

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.

Phillip M Jones

Inspiring

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.

M

mtthwmrrsnAuthor

Participant

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

Inspiring

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.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded