Solved

Print Selection - text running off page?

Posted on 2011-09-28
12
179 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
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

746 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

12 Experts available now in Live!

Get 1:1 Help Now