Excel 2004 shrinking printouts

L

Lardo

On 25 jan "is" posted a query with the same heading as above.
Unfortunately no one was able to provide a varifiable solution.

The reason I am posting this again is that I am having similar
problems. I have two objectives:

1. to acertain whether this is an isolated problem peculiar to myself
and "is". (hence the lack of feedback/posting on this forum)

2. to discover the reason and thus a solution to this fundemental flaw
in the software.

First some background:

The problem:

Files/worksheets that we have used for some years, when opened into
Excel 2004 printout smaller than when printed from Office X or any of
its previous encarnations. In our case the Shrinkage is purely vertical
and in our case amounts to a vertical scaling of about 93%. There is no
shrinkage horizontally.

The original files were set as templates before the days of Office 98
but have printed consistantly in every version since then. Has MS
changed something fundemental in the way Excel handles printing of
files in the 2004 version. The files are set up as invoice forms and
have round cornered objects set up to form "frames".

The symptoms above are consistant from whichever machine we print and
to a variety of printers using different drivers.

The same files imported into Excel 2003 on the PC scale horizontally by
75% and vertically 87%. In this case however, we are not surprised as
this has long been a problem when printing excel files cross platform
and I believe is attributed to the way excel defines its print area and
the screen dpi of Mac (72dpi) and windows (96dpi). This is the first
time I have seem it happen from the Mac after upgrading to a newer
version. Furthermore there seems little logical ties to the percentage
scaling involved.

We are printing the files with default setting ie 100%, no "fit to
page". The shrinkage is displyed in preview mode. The fonts used are
Palatino (type1), Arial and Times.

We are using PowerMac G4 DP 500s and G4 SP 400s running OSX 10.3.8 and
MS Office 2004 with update 11.1.1 applied. Printers are networked and
consist of various canon/HP colour and b/w machines using postscript
drivers provided by vendors.

I am puzzled that I have only found one specific entry on this forum
and almost nothing regarding this problem on the web given the
fundemental nature of the flaw. That is, if peoples prints were not
printing out the correct size I would expect a flood of postings.

This would tend to suggest that it is something peciliar to our set up.
however, this problem is repeatable across all our macines with Office
2004 installed and so it is proving hard to isolate the cause.

If anyone could suggest a possible cause/solution we would be much
obliged. This is driving us nuts as we cannot see a way around this one
and it makes anything we print using these files look daft.

Many thanks
 
B

Bob Greenblatt

On 25 jan "is" posted a query with the same heading as above.
Unfortunately no one was able to provide a varifiable solution.

The reason I am posting this again is that I am having similar
problems. I have two objectives:

1. to acertain whether this is an isolated problem peculiar to myself
and "is". (hence the lack of feedback/posting on this forum)

2. to discover the reason and thus a solution to this fundemental flaw
in the software.

First some background:

The problem:

Files/worksheets that we have used for some years, when opened into
Excel 2004 printout smaller than when printed from Office X or any of
its previous encarnations. In our case the Shrinkage is purely vertical
and in our case amounts to a vertical scaling of about 93%. There is no
shrinkage horizontally.

The original files were set as templates before the days of Office 98
but have printed consistantly in every version since then. Has MS
changed something fundemental in the way Excel handles printing of
files in the 2004 version. The files are set up as invoice forms and
have round cornered objects set up to form "frames".

The symptoms above are consistant from whichever machine we print and
to a variety of printers using different drivers.

The same files imported into Excel 2003 on the PC scale horizontally by
75% and vertically 87%. In this case however, we are not surprised as
this has long been a problem when printing excel files cross platform
and I believe is attributed to the way excel defines its print area and
the screen dpi of Mac (72dpi) and windows (96dpi). This is the first
time I have seem it happen from the Mac after upgrading to a newer
version. Furthermore there seems little logical ties to the percentage
scaling involved.

We are printing the files with default setting ie 100%, no "fit to
page". The shrinkage is displyed in preview mode. The fonts used are
Palatino (type1), Arial and Times.

We are using PowerMac G4 DP 500s and G4 SP 400s running OSX 10.3.8 and
MS Office 2004 with update 11.1.1 applied. Printers are networked and
consist of various canon/HP colour and b/w machines using postscript
drivers provided by vendors.

I am puzzled that I have only found one specific entry on this forum
and almost nothing regarding this problem on the web given the
fundemental nature of the flaw. That is, if peoples prints were not
printing out the correct size I would expect a flood of postings.

This would tend to suggest that it is something peciliar to our set up.
however, this problem is repeatable across all our macines with Office
2004 installed and so it is proving hard to isolate the cause.

If anyone could suggest a possible cause/solution we would be much
obliged. This is driving us nuts as we cannot see a way around this one
and it makes anything we print using these files look daft.

Many thanks

My first guess is that Palatino is the problem. Can you recreate the
template with another font supplied as part of Office? I think you are
correct in assuming that the problem is somehow related to your
use/configuration. Is the problem evident on all printers; particularly the
postscript vs. non postscript?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top