Link to home
Start Free TrialLog in
Avatar of DickJansen
DickJansen

asked on

Print Selection - text running off page?

I have a user with a fresh install of Office 2010. More specifically, no matter what excel file they open and try to select a certain block of text to print Excel shows the print preview of text running off the end of the page at the bottom. Also note they are using the "Print Selection" instead of the "Active Sheet". When they print the entire active sheet, the print preview looks normal - the problem only occurs when printing a selection. On my own PC Excel will simply put the overflowed text on to a new page to be printed on.

I've tried re-installing Office and going over all relevant settings for printing. It doesn't matter what printer is used either they all do the same. When the document actually is sent to the printer it looks exactly like the print preview as well - text running off the bottom.

The text is set to 95% and fits within the margins as well. I'm stumped as to why this happening only for this user.

PC:
Windows XP SP3
Office 2010

Any help is appreciated! Thanks
Avatar of Leo Torres
Leo Torres
Flag of United States of America image


Have you tried to set the print area as well...
I have seen this before I but don't remember how i solved it or if I did at all

try also open the run window and type  
excel /s
hit enter and see if you can also replicate this error in safe more
Avatar of DickJansen
DickJansen

ASKER

The print area defines a selection. That setting is grayed out in the print dialog when selecting "Print Selection" - it only applies when printing the "Active Worksheet".

I also tried running excel in safe mode but the problem still persists. I've tried removing one of the printers and adding it back in, but the same results still appear.

Thanks for the input.
Can we try selecting this area in question on the active page and just look at print preview to see if.. this still happens.


Another test can you save this particular file and try it on another PC runing the same version of office..

Yes, it happens on print preview as pointed out above. I took the file and opened it up on my own PC w/ Office 2010 (same version on user's PC) and print preview/printing all works normally when printing the selection. I don't think it has anything to do with the file. The user can replicate the issue on any excel file.

I am not talking about pring preview.. I want you to set the Print Area and see if that still happens
You can do this by Select the region to be printed  and going to Page Layout-->print Area--> Set Print Area

If Still giving you issues go to View-->Select page break Preview
This will tell you how the print pages are broken up that should help

I was not asking to replicate same error with another file. I want to see if you can replicate the same error with the same file on another PC
I have done everything you requested as my post above stated:

"The print area defines a selection. That setting is grayed out in the print dialog when selecting "Print Selection" - it only applies when printing the "Active Worksheet"."

Setting the print area had zero effect on the outcome of how the document would print in this case.

-and-

"I took the file and opened it up on my own PC w/ Office 2010 (same version on user's PC) and print preview/printing all works normally when printing the selection. I don't think it has anything to do with the file."

The page breaks are set by default, never been modified, and look at be fine.

Thank you...

Have you tried to see if some other program has the same issue on the same problematic computer..
I  would assume no or you may not have another program that can recreate this error.. but worth a try asking

Have you tried fooling around with the print drivers on the pc with issues. I see you tried to re-install office how about re-installing the drivers This seems to be a setting the pc has with the printer that may becausing this problem..
I have narrowed it down a little more:

My personal PC has Windows 7 64bit w/ Office 2010 32-bit SP1 - it displays the print selection perfectly.

The user with issues has Windows XP 32-bit w/ Office 2010 32-bit (NO SERVICE PACK). I tried replicating the problem on another identical setup and it did indeed happen again.

The problem seems to be Windows XP or Office 2010 SP1 related. I am now installing Office 2010 SP1 to see if that clears the issue up on my user's PC.

Oh I was under the impression that the PC were the same..

Hopefully The service pack update will fix this ..

Guess the next question is mine.. how the heck did you get office 2010 on XP??? I tried that and failed miserably..

Maybe this was becasue I had a 64 bit version.. :) hope that helps
The only prerequisite I know of for an XP install is that you must have XP SP3 installed. After updating it should install no problem!
ASKER CERTIFIED SOLUTION
Avatar of DickJansen
DickJansen

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
none...