Printing in Excel 97 creates different results from different computers 
Author Message
 Printing in Excel 97 creates different results from different computers

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!


Tue, 13 Jul 2004 12:24:26 GMT  
 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!



Tue, 13 Jul 2004 18:43:38 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. different computers, different views and prints

2. Excel 95: different start, different results?

3. Printing to different printers for different users in '97

4. Printing to different printers for different users in '97

5. Printing the same Excel file on different computer to same printer

6. ShowOpen returns different results on different PCs

7. Get different results from math on different sheets in same workbook

8. Different PCs return different query results

9. Nz Function - Different Clients, Different Results

10. ACCESS V2.0 - DIFFERENT RESULTS ON DIFFERENT PC


 
Powered by phpBB® Forum Software © phpBB Group