Software

Ask something
Discussion Locked

Cannot change Excel print format

0 helpful
3 replies

by bryan_h

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Excel 97. User has a spreadsheet which he revises and reissues. Probably the original version was in portrait, but the report has grown and now requires landscape. Can send to a colleague who can change to landsape and print OK, but the originator can select landscape, but only print in portrait. When page setup is re-opened it has reverted to portrait. Copying the contents into a new worksheet does not change the situation. Worksheet is not protected.

3 replies

by dklippert

Can your user print landscape to a different printer?
Check printer driver set default to landscape and see if it prints.
Make sure you have the latest driver.
(For Macs, there has been a problem with Laserwriter 8.4)

All of this assumes thatthere are no views being called by a macro (AutoOpen). Probably not, if it works on another machine. My bet is Printer.

by bryan_h

This was valid and worth checking. However the user who was able to print, was using the same network printer. Yes the spreadsheet can be printed in landscape to another network printer. Pointed me in the right direction. Sorry for delay. Pay the points.

This discussion is closed to new replies.