Printing in Excel 97 creates different results from different computers
Hi Blake,
This is a big problem with Excel and there aren't very many good
answers. It's caused by the fact that Excel renders a printed workbook
differently for different combinations of printer and video drivers. Unless
you have two computers that are *exactly* the same you can't be sure that a
worksheet printed on them will come out looking the same.
You basically have two choices. The first is to create a report that is
structured so it prints acceptably well on all of machines where it will be
printed. The second is to write gobs of custom code and worksheet structures
that read things like where the current machine is placing page breaks and
then adjusts the printed output so that the report looks great on every
machine (but still different).
If you really need things to look exactly right, every time, with no
exceptions, the only thing to do is to designate a single report printing
computer. Set up the report on that computer so that it prints out exactly
how you want it to, then always print the report on that computer.
--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/
* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *
Quote:
> I am the system administator at a Accounting office. We
> use Excel 97 (with SR2 installed). When printing financial
> reports from different computers, same printers, same
> files, there are differences in the printout. Out of 4
> users there is always one who gets a printout that is just
> a little bit compressed or expanded! This has been a
> problem for awhile and I haven't found anything to help. I
> checked to make ALL settings are exactly the same (font,
> size, options etc) and even though they are we still get
> different results. Has anyone else had this problem or
> even better know a fix for this problem!
