Solved

Print Selection - text running off page?

Posted on 2011-09-28
12
190 Views
Last Modified: 2013-11-05
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
0
Comment
Question by:DickJansen
  • 7
  • 5
12 Comments
 
LVL 8

Expert Comment

by:Leo Torres
ID: 36812916

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
0
 

Author Comment

by:DickJansen
ID: 36815931
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.
0
 
LVL 8

Expert Comment

by:Leo Torres
ID: 36816275
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..

0
 

Author Comment

by:DickJansen
ID: 36816456
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.
0
 
LVL 8

Expert Comment

by:Leo Torres
ID: 36816865

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
0
 

Author Comment

by:DickJansen
ID: 36893743
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...
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 8

Expert Comment

by:Leo Torres
ID: 36893794

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..
0
 

Author Comment

by:DickJansen
ID: 36893826
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.
0
 
LVL 8

Expert Comment

by:Leo Torres
ID: 36893871

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
0
 

Author Comment

by:DickJansen
ID: 36893882
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!
0
 

Accepted Solution

by:
DickJansen earned 0 total points
ID: 36893893
Installing Office 2010 SP1 fixed this issue!
0
 

Author Closing Comment

by:DickJansen
ID: 36915528
none...
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now