Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Printing Problem Excel 97 to 2000

May 25, 2004 3:10AM PDT

My Excel spreadsheet with macros prints fine on my older machine under Excel 97 and Win 98, but when I try it on my new machine under Excel 2000 and Win XP, the one page document is split and the bottom half will only come out as page 2. Any suggestions on correcting this?

Discussion is locked

- Collapse -
Re:Printing Problem Excel 97 to 2000
May 25, 2004 4:26AM PDT

This may only happens around Gastown in Vancouver, but my bet is that the printer drivers are not exactly the same or the printer changed.

Windows, right or wrong reformats according to the printer capabilities. An user or driver can set more margin and what fit on one setup will not on another.

You have to dig this one out.

Bob

- Collapse -
Re:Re:Printing Problem Excel 97 to 2000
May 25, 2004 11:13PM PDT

I have two identical laser printers, one on each computer. The only difference appears to be the operating systems, Win 98SE on one and Win XP on the other. All the other Office documents that I try to print out on each are compatible. Thanks for trying.

- Collapse -
Printer drivers are not "identical."
May 25, 2004 11:23PM PDT

You need to dig in and see if any nuance such as fonts (which are not the same), unprintable areas (a printer driver or setting) is causing Excel to format it differently.

Just curious, why "skytrain?" I lived in the Vancouver, BC area for 8 years. Greatest place in the world I've ever lived in.

Bob

- Collapse -
Also ...
May 27, 2004 5:15AM PDT

1. The printers might be identical, the printer drivers surely are not. XP needs another version then Windows 98.
2. The spreadsheets might be the same, but the versions of Excel aren't.

Hence, why do you suppose that a different program with a different printer would give exactly the same result?

Try correcting the situation by adjusting the margins, printing at 99% of size, or forcing Excel to print to 1 by 1 page. If one of those work-arounds works (and there ain't no reason why they all wouldn't) and this is the only one of your spreadsheets needing such a correction, I wouldn't mind at all.

Hope this helps.


Kees

- Collapse -
(NT) Meant 'printer driver', not 'printer' in sentence starting with 'Hence'.
May 27, 2004 7:37AM PDT

.