A4 PDFs from Office 2007

Hi,

I'm using Excel 2007, with the very useful 'save to PDF or XPS' Add-In. All
PDFs I generate using it are 11"x8.5", instead of A4, which is the paper
stock all my fairly non-technical clients will be using.

Changing the page setup options does not affect the generated PDFs, and
there doesn't seem to be a separate option to change page size within the
Save-As dialogue.

I realise that I could probably do this with an external application such as
Acrobat, but I'm keen to hand over the process of PDF report generation to a
non-technical colleague, and would like if possible, the cost of buying
Acrobat and the complication of introducing another application to the
process.

So, how does one get one's PDFs to default to A4 page size?

Many thanks for any thoughts.

... and would like if possible, the cost of buying
Acrobat and the complication of introducing another application to the
process...

Of course, this should have read 'would like TO AVOID if possible'!

Just thought I'd bump this after a day. Nobody got any thoughts?

Bumping doesn't work in here. If no one has an answer, no one responds.

--
JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375


"John Swire" wrote in message
...
Just thought I'd bump this after a day. Nobody got any thoughts?

I see that is certainly true of the web gateway but whether it works on NNTP
clients or not depends on client behaviour and configuration. Dedicated
clients are certainly liable to show new activity in a thread (eg by
emboldening it) which might remind people who had an answer but had not yet
posted to do so.

I must admit however, you are unequivocally right on one point; it looks to
me as if there is no obvious solution of this problem, and that this is a
shortcoming which has existed since PDF-writing was introduced in Mac Office
2004, see he
http://blogs.msdn.com/macmojo/archiv...es.aspx#831175

I will attempt a delve into the registry at some point to see if there is
anything obvious, and report back here if I have time.

"JoAnn Paules" wrote:

Bumping doesn't work in here. If no one has an answer, no one responds.

--
JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375


"John Swire" wrote in message
...
Just thought I'd bump this after a day. Nobody got any thoughts?

I don't know what Office 2007 uses to create PDF's, BUT you may want to
look in Windows Print Server Properties Forms tab and see if A4 even
exists on your system. If it doesn't even exist, then you will never
have it available anywhere on any print device. See Windows Help "Print
Server Properties" for particulars and instructions.

John Swire wrote:

I see that is certainly true of the web gateway but whether it works on NNTP
clients or not depends on client behaviour and configuration. Dedicated
clients are certainly liable to show new activity in a thread (eg by
emboldening it) which might remind people who had an answer but had not yet
posted to do so.

I must admit however, you are unequivocally right on one point; it looks to
me as if there is no obvious solution of this problem, and that this is a
shortcoming which has existed since PDF-writing was introduced in Mac Office
2004, see he
http://blogs.msdn.com/macmojo/archiv...es.aspx#831175

I will attempt a delve into the registry at some point to see if there is
anything obvious, and report back here if I have time.

"JoAnn Paules" wrote:


Bumping doesn't work in here. If no one has an answer, no one responds.

--
JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375


"John Swire" wrote in message
...

Just thought I'd bump this after a day. Nobody got any thoughts?