Excel 2010, Win7, set to Landscape, prints Portrait, cuts off document

I have a user on Win 7 Pro 64 bit, Excel 2010.

She has spreadsheets that she has used for years which print landscape. She is training a new user and she thinks the new employee changed "something" in the formatting or options to mess it up. When she tries to print landscape as she always has, it comes out Portrait and only prints about 1" of the left hand side, all the way down.

I uninstalled the printer (HP Officejet Premier 8500 a900n) and reinstalled the whole thing. No fix.

One thing that *does* fix it is going to Printer Properties, Advanced and switching from "Spool print documents..." to "Print directly...". But we don't want to use that as a workaround. It should work as it used to.

I found that the reason that works is because if you switch it back to "Spool print documents..." and UN check "Enable advanced printing features" it also works. So it seems there is something in there which is screwing it up.

Any ideas?
RickNCNAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

JohnBusiness Consultant (Owner)Commented:
Have changes been made to the Print Layout in Excel?  I would guess yes. I think these override the physical printer settings.

... Thinkpads_User
0
RickNCNAuthor Commented:
Where is "print layout"? I've heard of "page layout view" and "print area".
0
JohnBusiness Consultant (Owner)Commented:
Sorry - I was just using a generic term.

Open Excel, go to the Page Layout tab, click on the little x to the right of the word Page Setup. The traditional Page Setup Dialogue Window opens.

You can set up the page as you wish. Landscape and Portrait is there. You user could have set the "Fit to" setting as well, forcing a different looking output. That has happened to me when I have looked at client worksheets.

.... Thinkpads_User
0
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

duttcomCommented:
If you go to the View tab and click on the Page Break Preview button on the left, do the pages appear as they are supposed to there?
0
RickNCNAuthor Commented:
This I checked already and it *is* set properly, for landscape

Open Excel, > Page Layout tab, > click on the little x > The traditional Page Setup Dialogue Window opens.

This part I'll have to double-check:

You user could have set the "Fit to" setting as well,


And as for this:
If you go to the View tab and click on the Page Break Preview button on the left, do the pages appear as they are supposed to there?

yes, I checked that and it looks correct.
0
JohnBusiness Consultant (Owner)Commented:
Please let us know.

Other things to consider at this point.

1. If it is this one workbook only and other workbooks work properly, then open the problem workbook, and a new workbook. Copy the data and formulas from old to new. Check out the new workbook. Now save it as a new document.

2. If ALL workbooks are wrong, uninstall Office completely, restart the computer and then install Office again (full, not typical, except for languages not needed). Add the 3 service packs and update fully. Restart and test.

... Thinkpads_User
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
RickNCNAuthor Commented:
You user could have set the "Fit to" setting as well,

That was a negative, "Fit to" was not turned on.

It is not just one workbook but all landscape workbooks. She tested many. Probably a dozen or so. She also received one in email and tried it - same result.

Uninstall & reinstall Office? really? ugh! I really don't want to do that. There's got to be a setting, no? It happened after a new employee got to the spreadsheet - someone who doesn't listen to "don't mess around with settings" and likes to do her own thing.
0
JohnBusiness Consultant (Owner)Commented:
It appears to be one machine. Uninstall Office takes 5 minutes or so. Restart and install takes about 10 minutes or do. Updating takes 15 minutes or so. It is not an onerous task and seems like the next thing to consider.

Also try this in a new test Windows User Profile (Account). It may be a corrupted user profile causing the issue.

... Thinkpads_User
0
RickNCNAuthor Commented:
I was able to do a test on another printer but same PC. It printed correctly! I moved an HP 5900 series to this pc  - Windows 7 loaded the drivers (there are no HP Win7 drivers) and it printed the landscape sheet just fine.

This tells me it is not Excel, or Office. There has got to be a setting, OR something in the HP 8500 driver is corrupt (although I did uninstall/reinstall it) OR something corrupt in how Windows is handling the spool file?

I am uploading three images of the printouts.
#1 will be the correct print of the sheet in landscape on the HP 5900.
the correct print of the sheet in landscape on the HP 5900#2 will be a correct portrait printing from the HP 8500
a correct portrait printing from the HP 8500#3 will be the INcorrect landscape print from the HP 8500 which comes out portrait
the INcorrect landscape print from the HP 8500 which comes out portrait
Notice how the spacing in the rows in #1 and #2 are the same, consistent. And they differ from the spacing in #3. The height of the rows is "stretched" taller. This isn't something Excel would do if it were actually printing a true portrait printout.

Also, the line that cuts off the right edge seems totally arbitrary, it's not the edge of a column or cell. Looks like something Windows is doing - like a spool file isn't loading or being created all the way.

Looks like more of a "hardware / printer" or "O.S." issue, not an Excel issue.
0
JohnBusiness Consultant (Owner)Commented:
Could be. I have an HP8500 printer in my Home Office and none of this occurs because of the Printer, both on Windows 7 / Excel 2010 and Windows 8 / Excel 2013. The printer is fine. However, I have kept this printer up to date, so do run the Printer Update.

If Windows, start considering things like:

1. SFC - Run SFC /SCANNOW, allow to complete and restart.

2. Perhaps consider a Windows 7 Repair Install. I posted a Seven Forums link with a tutorial for this.

http://www.sevenforums.com/tutorials/3413-repair-install.html

Also, you have not yet commented on whether this issue occurs in a different Windows User Account.

.... Thinkpads_User
0
RickNCNAuthor Commented:
It does occur under a different Windows User Account, yes.

The user created a new spreadsheet from scratch, copying nothing from any other sheet and it did the same thing.

Since it's not happening with the 5900 and always does happen with the 8500 I want to think it's an 8500 driver problem. I did uninstall and reinstall the software. Is there something else I need to do to really scrub the drivers off the system before reinstalling maybe?
0
JohnBusiness Consultant (Owner)Commented:
To completely remove any printer, remove the printer from the main dialogue box. Next, click once on any printer to activate the sub-menu. Select the Printer Server Properties, and select the drivers tab.

In the case of the HP8500, there will be at least one, maybe two Printer Drivers and one Fax driver. The may be an HP8600 driver. I have one, and that may be because I have a client with an HP8600. In any event, remove all HP8xxx drivers.

Restart the computer and install again.

Just to restate, I have an HP8500 in my Home Office, a Windows 7 Pro 64-bit Desktop with Office 2010, a Windows 7 pro 64-bit Laptop with Office 2010 and a Windows 8 Pro 64-bit Laptop with Office 2013. I have no printer or Excel problems with any of these setups.

.... Thinkpads_User
0
RickNCNAuthor Commented:
I keep coming back to the fact that it all worked fine on this setup - HP 8500 Premier (a909n i think) and Excel - for months / years. New employee who is click happy and does her own thing got into printing the spreadsheet her own way and now it's munged up.

Update* Original user's son - an ex-IBMer came in and clicked through some settings and made it print correctly. User has no idea now what he did. I need to find out. I think he found the reason for it.
0
JohnBusiness Consultant (Owner)Commented:
Please let us know when you find out. It is likely a setting in Excel (which is what we were discussing way back here).

... Thinkpads_User
0
RickNCNAuthor Commented:
I should know shortly. The guy who came in and fixed it should be back from a trip. I will post the answer as soon as I find out.
0
RickNCNAuthor Commented:
Thanks for the help. I haven't heard back from the user and her son about what he did to solve it. When I do, I'll post an update here. I tallied up the amount of responses by column-inches and weighted it plus or minus by quality of content and came up with a "12" for "thinkpads_user" and a 1 for "duttcom", total 13. That's .08 of the points or 40 for duttcom and 460 to thinkpads.
Thanks!
0
JohnBusiness Consultant (Owner)Commented:
@RickNCN - Thank you for the update and I was happy to offer assistance here.

.... Thinkpads_User
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.