Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Print Selection - text running off page?

Posted on 2011-09-28
12
Medium Priority
?
223 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

715 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