+ Reply to Thread
Results 1 to 13 of 13

Excel 2007 : Excel 2007 prints portrait,landscape,portrait,landscape,etc.

  1. #1
    Registered User
    Join Date
    07-15-2010
    Location
    Omaha, Nebraska
    MS-Off Ver
    Excel 2007
    Posts
    32

    Excel 2007 prints portrait,landscape,portrait,landscape,etc.

    Multipage documents print in portrait then landscape then portrait then landscape, etc. That is each file. So if the worksheet if 6 pages, I get 3 in portrait and 3 in landscape. They alternate with each page. If I change the setting to landscape, then it goes landscape, portrait, landscape, portrait, landscape, portrait. I am an IT administrator for a small company. We have 4 servers and 25 PC's. This started on one a while ago but 2 more started doing it in the last few days.

    Each PC has it's own copy of Microsoft Office 2007 loaded on it. They all come from one disk that we purchased from Microsoft with unlimited licensing.

    Any help is greatly appreciated.

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Excel 2007 prints portrait,landscape,portrait,landscape,etc.

    Is this:
    1. All workbooks, or just some?
    2. No matter which printer you print to?
    3. Only happening with Excel?
    Remember what the dormouse said
    Feed your head

  3. #3
    Registered User
    Join Date
    07-15-2010
    Location
    Omaha, Nebraska
    MS-Off Ver
    Excel 2007
    Posts
    32

    Re: Excel 2007 prints portrait,landscape,portrait,landscape,etc.

    It happens with every multipage workbook.

    Yes, if I choose another printer it does the same thing.

    Yes, only Excel. Word does just fine with multipage docs.

  4. #4
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Excel 2007 prints portrait,landscape,portrait,landscape,etc.

    Does it happen if you open Excel in Safe Mode by holding down the Ctrl key when opening it?

  5. #5
    Registered User
    Join Date
    07-15-2010
    Location
    Omaha, Nebraska
    MS-Off Ver
    Excel 2007
    Posts
    32

    Re: Excel 2007 prints portrait,landscape,portrait,landscape,etc.

    Will have to try that....I will let you know...

  6. #6
    Registered User
    Join Date
    07-15-2010
    Location
    Omaha, Nebraska
    MS-Off Ver
    Excel 2007
    Posts
    32

    Re: Excel 2007 prints portrait,landscape,portrait,landscape,etc.

    Yes it still printed bad in safe mode

  7. #7
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Excel 2007 prints portrait,landscape,portrait,landscape,etc.

    My prime suspect would be printer drivers then since Excel doesn't have the option to print like that.

  8. #8
    Registered User
    Join Date
    07-15-2010
    Location
    Omaha, Nebraska
    MS-Off Ver
    Excel 2007
    Posts
    32

    Re: Excel 2007 prints portrait,landscape,portrait,landscape,etc.

    Worth a try. I will reinstall the printer drivers in all three machines and let you know if that helps. Thanks.

  9. #9
    Registered User
    Join Date
    07-15-2010
    Location
    Omaha, Nebraska
    MS-Off Ver
    Excel 2007
    Posts
    32

    Re: Excel 2007 prints portrait,landscape,portrait,landscape,etc.

    I reinstalled the printer drivers. I had the PCL 6 version. I take care of 20+ PC's on out network. When I move them, I routinely just go to the manufacturers site and download the newest version. The common thread on this issue is the printers are all HP LaserJet P2015. I had installed the PCL 6 version and the Universal Printer Driver. I then went back to the PCL 5 version. Now the Excel Documents print the opposite of what it says it is doing. So. if I set the document to landscape, it prints in portrait. If I set it to portrait, it prints in landscape. This could be fine but the problem is that when you look at the print preview, it has it in the other and so the margins are in the other. So a document I need in landscape is cut off according to the portrait margins and I can't get the entire document to print right.

  10. #10
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Excel 2007 prints portrait,landscape,portrait,landscape,etc.

    Is there a PostScript driver you can use, or a more generic driver? (Excel and HP drivers have a long and somewhat chequered history)

  11. #11
    Registered User
    Join Date
    07-15-2010
    Location
    Omaha, Nebraska
    MS-Off Ver
    Excel 2007
    Posts
    32

    Re: Excel 2007 prints portrait,landscape,portrait,landscape,etc.

    I have seen the postscript drivers at the HP site. Should I use one of those for my printers?

  12. #12
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Excel 2007 prints portrait,landscape,portrait,landscape,etc.

    I'd certainly try one and see if it's any better.

  13. #13
    Registered User
    Join Date
    07-15-2010
    Location
    Omaha, Nebraska
    MS-Off Ver
    Excel 2007
    Posts
    32

    Re: Excel 2007 prints portrait,landscape,portrait,landscape,etc.

    Ok...will try that and see if it helps. Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1