Question

Excel zooms to 400% view when laptop is connected to projector

Asked by: mikeosb

This problem occurs on a Dell Precision M70 laptop running Windows XP SP2 & Excel 2002 (Office XP).  The video card in this unit is an nVidia model, and the drivers have been updated to the latest rev as posted by Dell.

When docked or in standalone mode, performance is normal when using Excel or any other application.  However, when this laptop is connected to an Epson projector, the screen automatically zooms to 400% normal view when a cell is selected or the worksheet is scrolled.  No amount of toggling between the laptop display and the projector will reset the video back to the default.  The overall Windows desktop appears to take on a low-resolution, large size icon scheme when this problem happens in Excel.

The only 'fix' I've found thus far is to shut down cold, which will restore the laptop to it's normal display mode.

There is a similar posting in one of the forums for a PowerPoint problem, but I require more than a 'adjust the video settings' suggestion for a solution.

Thanks, and good luck.

This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.

Subscribe now for full access to Experts Exchange and get

Instant Access to this Solution

  • Plus...
  • 30 Day FREE access, no risk, no obligation
  • Collaborate with the world's top tech experts
  • Unlimited access to our exclusive solution database
  • Never be left without tech help again

Subscribe Now

Asked On
2006-05-23 at 17:18:44ID21861487
Tags

zooms

,

projector

,

excel

Topic

Miscellaneous Software

Participating Experts
8
Points
0
Comments
18

Trusted by hundreds of thousands everyday for fast, accurate and reliable tech support.

  • "The time we save is the biggest benefit of Experts Exchange to Warner Bros. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange." Mike Kapnisakis, Warner Bros.
  • "Our team likes having a resource that is more secure than just using Google and most experts using this service really know their stuff. It's nice to look here first versus using Google." Dayna Sellner, Lockheed Martin
  • "Anytime that I've been stumped with a problem, 9 out of 10 times Experts Exchange has either the accepted solution or an open discussion of the potential solution to the problem." Kenny Red, eBay Inc.

See what Experts Exchange can do for you.

Got a question?

We've got the answer.

Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.

Screenshot of Experts Exchange Knowledgebase

Need individual assistance?

Our experts are ready to help.

If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.

Screenshot of Experts Exchange Knowledgebase

Want to learn from the best?

Read articles from industry experts.

Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.

Screenshot of an Article

Working on a long term project?

Store your work and research.

Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.

Screenshot of Experts Exchange Knowledgebase

Access the answers to your technology questions today.

Subscribe Now

30-day free trial. Register in 60 seconds.

What Makes Experts Exchange Unique?

Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Trusted by the world's most respected brands.

image of each brand's logo

Faithfully serving IT professionals since 1996.

Experts Exchange Logo

Try it out and discover for yourself.

Subscribe Now

30-day free trial. Register in 60 seconds.

Related Solutions

  1. projector
    I have a proxima desktop projector 5900 and everytime I start a windows media player files in srunches up. It works fine in windows. I have a ceo that has a presentation that has a imbeded video file in a powerpoint presentation. when the presentation goes it looks fine, but ...
  2. Projector
    I am looking for a Projector in the range of $600 - $800 dollars that will fit my needs. I have a room that I have blinds on but the sun still shines in a little looks about like a 20w light is shining on the wall so I will need a around a 1200+ L Projector. #1 I am going to...
  3. Projector
    It seems like I remember reading about some of the newer projectors having the ability to upload a powerpoint presentation directly to the projector itself and not have to hook up a computer when you give the presentation. Does anyone have any experience with this? thanks d...
  4. Projectors
    Hi Guys (and girls) I need to try and find a projector with a usb/usb2 port that will automatically detect powerpoint slides. The idea is that when we do presentations, we wont need a laptop, we can just plug the USB key into the projector and the presentation (*.ppt) will ...
  5. digital projectors
    I am evaluating digital projectors for my classroom. I would appreciate any feedback about LCD projectors that you use. I am looking at the Epson Powerlit 76C. It seems like 2000 lumens and XGA video are minimum requirements. Thanks JDF

Free Tech Articles

  1. WARNING: 5 Reasons why you should NEVER fix a computer for free.
    It is in our nature to love the puzzle. We are obsessed. The lot of us. We love puzzles. We love the challenge. We thrive on finding the answer. We hate disarray. It bothers us deep in our soul. W...
  2. SCCM OSD Basic troubleshooting
    SCCM 2007 OSD is a fantastic way to deploy operating systems, however, like most things SCCM issues can sometimes be difficult to resolve due to the sheer volume of logs to sift through and the dispe...
  3. Migrate Small Business Server 2003 to Exchange 2010 and Windows 2008 R2
    This guide is intended to provide step by step instructions on how to migrate from Small Business Server 2003 to Windows 2008 R2 with Exchange 2010. For this migration to work you will need the fo...
  4. Create a Win7 Gadget
    This article shows you how to create a simple "Gadget" -- a sort of mini-application supported by Windows 7 and Vista. Gadgets can be dropped anywhere on the desktop to provide instant information, ...
  5. Outlook continually prompting for username and password
    There have been a lot of questions recently regarding Outlook prompting for a username and password whilst using Exchange 2007. There are a few reasons why this would happen and I will try to cover t...
  6. Backup Exchange 2010 Information Store using Windows Backup
    There seems to be quite a lot of confusion around the ability to backup Exchange 2010 using the built in Windows Backup feature. This stems from the omission of this feature prior to Exchange 2007 s...

Cloud Class Webinars

  1. Avoiding Bugs in Microsoft Access
    Alison Balter takes and in-depth look at avoiding bugs in Access. In this webinar you will learn about using the immediate window to debug your applications, invoking the debugger, using breakpoints to troubleshoot, stepping through code, setting the next statement to execute, ...
  2. Top 10 Best New Features in Visio 2010
    Scott Helmers gives live demonstrations of the top 10 new features in Visio 2010. This webinar will teach you how to create compelling diagrams by adding shapes to the page with a single click, linking the shapes in a diagram to data in Excel (or SQL Server, or SharePoint), ...
  3. IT Consultant Business Secrets Revealed
    Michael Munger, Experts Exchange tech pro and IT consultant, pulls back the curtain on his very successful businesses and answers question on every IT consultant and business owner should know about. He shares secrets on what he did to solve the 5 most common problems in IT, ...
  4. Disaster Recovery and Business Continuity
    Quest CTO, Mike Billon, gives an overview of the steps involved in building a dunamic disaster recovery plan. Through case studies and an examination of software/hardware tooles for monitoring and testing, you'll gain a better understandin of where you are, where you want ...
  5. Organize Your Visio Diagrams with Containers and Lists
    Scott Helmers uses cross functional flowcharts, wireframe diagrams, data graphic legends and seating charts to teach you: how to ustilize all three new structured diagram components in Visio 2010, the best practices for organizeing shapes in previous version of Visio, how to organize ...
  6. How to Us Objects, Properties, Events and Methods in Microsoft Access
    Alison Dalter gives an in-depbth look at objects, properties, events and methods in Microsoft Access. In this webinar you will learn about using the object browser, referring to objects, working with properties and methods, working with object variables, understanding the ...

Join the Community

Give a Little. Get a Lot.

Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.

Join the Community

Answers

 

by: rbmacrossPosted on 2006-05-23 at 18:58:44ID: 16748001

The problem could be that the projector can not handle the video display settings of the laptop.  I suggest trying to reduce the display settings on the laptop to 800x600 and go up from there to see what works for you.

 

by: TheSipPosted on 2006-05-23 at 21:19:22ID: 16748412

i would try reinstalling excel if that doesn't work. if the problem persists call microsoft

 

by: moorhouselondonPosted on 2006-05-24 at 00:20:01ID: 16749041

Have you tried using the twin screen facility as a workaround?  (Or perhaps it is in two screen mode and can't handle it).  Setup the projector as the second screen and then move the spreadsheet onto it, see if that works.

 

by: mikeosbPosted on 2006-05-24 at 13:26:25ID: 16755590

I can add that it doesn't matter whether the display is set to laptop only, projector only or both simultaneously.  Click a cell or scroll within Excel & you're toast.

 

by: moorhouselondonPosted on 2006-05-24 at 13:48:06ID: 16755737

The fact that the hangup occurs on clicking on an application indicates to me that this is a video driver problem.  (Yes I hear what you say - you have the latest version),

Have you tried slugging the video properties (number of colours, rbmacross has already suggested reducing the resolution)?  Does anyone here think that the version of DirectX currently loaded will make any difference?  (Excel does interact with DirectX)

 

by: scrathcyboyPosted on 2006-05-24 at 21:35:36ID: 16757915

start - programs -accessories - accessibility - magnifier.  Look at that for a moment, it is 400% magnification.

When the device driver for the projector installed, it was set as an "accesibility" device, and pickup up those settings.  Therefore, you need to get into the actual device driver for the projector and change those settings there.  Now this device drive MAY be acccessible through an Epson projector option (look for that in control panel, or go to start, settings, control panel, projectors, and look for it).  If you find, make those changes there.  If you cant find, right click My computer, properties, hardware device manager, find the porojector device, find the installed drivers for it, and change the settings for those drivers in the registry, start, run, regedit, search F3 for the projector name, fix there.

Normally, there is an application module to install for any device like a projector that lets you make these adjustments, you should not have to do it in the registry .. but alas, bad software ... sometimes you have to resort to the registry.

 

by: mikeosbPosted on 2006-05-25 at 07:54:40ID: 16761292

I agree with it most likely being a combination of resolution & driver settings, and the Accessibility options had crossed my mind too.  I hadn't thought about DirectX though since Excel isn't multimedia! The new nVidia driver does have a sync dual monitor settings function, so I'm keen to try that.  Once I can pry the unit away from the user (yes...it's one of those 'critical' issues where one can never have the unit away from the user long enough to flesh the problem out), I'll test all of these out & post my findings.  Thanks all.

 

by: moorhouselondonPosted on 2006-05-25 at 11:50:45ID: 16763237

Excel isn't multimedia - but it can make use of DirectX.  Look for instance at the Excel Easter Egg which makes use of DirectX.

 

by: NerdxPosted on 2006-06-01 at 03:03:43ID: 16805925

Dear mikeosb,

Does the screen size of 400% go up if you press the keys Fn + F8?

~ Nerd

 

by: NerdxPosted on 2006-06-01 at 03:09:38ID: 16805948

Have you tried reducing the magnification level using the projector remote? This is the only solution I've seem to come across... so far.

~ Nerd

 

by: NerdxPosted on 2006-06-01 at 03:36:32ID: 16806063

Another solution: Disable scrolling feature or Remove Intellipoint software

~ Nerd

 

by: mikeosbPosted on 2006-06-02 at 07:56:19ID: 16817247

Wonder of wonders, I may actually have a chance to work on this unit today if the user will part with it!

For Nerdx, the problem only occurs when the screen is scrolled or when a cell is selected.  Toggling the display (internal, external, both) doesn't seem to have an effect.

 

by: mikeosbPosted on 2006-06-03 at 04:48:57ID: 16823065

OK, here's some other symptoms & the actual solution.  I mentioned that this problem occurred in Excel, and that I had also seen a report of the same issue in PowerPoint.  In this case, opening PowerPoint and attempting to move the scroll bar while connected to the projector also produced a 400% zoom.  I took this one step further and also opened a Word doc under the same conditions, and when I tried to scroll the document it zoomed to 500% magnification.

Here's the solution - the only video setting that I changed that made any difference was the default font size under Advanced Properties.  Instead of the default setting of Small 96 DPI fonts or Large 120 DPI fonts, the user had enabled an odd size of 152 DPI, which apparently MS-Office can't deal with under these conditions (internal & external displays).  I tested with resolutions up to 1920x1024 (nVidia custom res) at both 96 DPI & 120 DPI, and the display never hiccuped once.

Thanks for the input, and I wish that I had a clear-cut winner to award the points to.  I wonder if Experts-Exchange will refund my 10 bucks? :-)

 

by: NerdxPosted on 2006-06-04 at 05:13:52ID: 16826891

Nice find, mikeosb. I had been looking for a solution to this problem for you for ages. I also found that many other people were encountering this same problem and also couldn't find a fix.

Good work!

P.S: Why not become an expert?

~ Nerd

 

by: DarthModPosted on 2006-07-22 at 07:43:55ID: 17160101

PAQed with points refunded (500)

DarthMod
Community Support Moderator

 

by: brwillis1Posted on 2006-09-18 at 10:09:20ID: 17545090

mikeosb stated that the solution was "the only video setting that I changed that made any difference was the default font size under Advanced Properties.  Instead of the default setting of Small 96 DPI fonts or Large 120 DPI fonts, the user had enabled an odd size of 152 DPI, which apparently MS-Office can't deal with under these conditions (internal & external displays)."
 However, I have tested that on several different models of Dell Precision and Latitude laptops and could not get the same results.  Instead I got rid of our "Excel zooms to 400%" problem by removing Microsoft "Intellitype" software.  After removing Intellitype and rebooting, the zooming problem goes away even after pressing Fn-F8 to change the display/projector mode. (I can re-install Intellitype and the problem will re-appear).
Mikeosb's solution may have worked in his instance, but I have also tested and verified that Intellitype also is a culprit that causes Excel to zoom to 400% after pressing Fn-F8. (Nerdx came close to the solution when he mentioned removing Microsoft "Intellipoint" software ("Intellipoint" is for Microsoft mouse, "Intellitype" is for Microsoft keyboards)
 

 

by: TrelleborgPosted on 2009-06-16 at 12:23:50ID: 24641486

I know this is dead but i just had the same problem yesterday, for the second time.  The first time it happend a long time ago, I swapped out the users keyboard and mouse from Microsoft ones to Logitech ones, removing Intellitype/point, and installed Logitechs drivers.  this fixed the issue for no reason I can figure.  So yesterday the problem came back with a different user.  So my question is...  Is there Microsoft Intellitype or Intelliprint installed?  I just uninstalled the bloated Intelli drivers, and let Windows automatically use default generic keyboard and mouse drivers.  This does turn off the functionality of some fancy keyboard buttons, but most standard users do not use those anyway.  Hope this helps.  

20120131-EE-VQP-002

3 Ways to Join

30-Day Free Trial

The Experts

98% positive feedback on 31,087 answers since March 2000. angeliii is a Microsoft Most Valuable Professional for his work with MS SQL Server & Develoment.

He has also proven his knowledge of Visual Basic Programming, PHP Scripting and Oracle Databases.

The Experts

97% positive feedback on 10,752 answers since July 2000. lrmoore has more than 18 years experience in the networking industry.

The six-time Mircosoft MVPs specialties include firewalls, virtual private networking, and network management.

Testimonials

"...and excellent source for support... Kind of like having your very own IT dept." Electriciansnet

Testimonials

"I was apprehensive at signing up at first. However... it has already made my life as an IT administrator much easier." JaCrews

Testimonials

"WOW! You guys have great, active, and knowledgeable people on here." moore50

Business Clients

Business Clients

In the Press

"If you’ve got a question... Experts Exchange can supply an answer.”

In the Press

"...an invaluable aid for both IT professionals and those who require tech support."

In the Press

"where IT professionals provide quick answers on just about any topic"

Business Account Plans

Loading Advertisement...