Microsoft Knowledge Base Email Alertz

A runtime error occurs and then Office Excel 2007 crashes when you programmatically print or print preview a file in Microsoft Office Excel 2007

Search KbAlertz

Advanced Search

Receive Microsoft Knowledge Base articles by E-Mail?

Every night we scan the Microsoft Knowledge Base. If technologies you're interested in are updated, we'll send you an e-mail. You only get one e-mail a day, and only when new articles are added.

Click here to create a
FREE account
Already have an account?
[Click here to Login]











Microsoft Knowledge Base Article

This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks

Article ID: 979370 - Last Review: July 20, 2011 - Revision: 1.0

A runtime error occurs and then Office Excel 2007 crashes when you programmatically print or print preview a file in Microsoft Office Excel 2007

SYMPTOMS

Consider the following scenario:
  • You have a computer that is running Microsoft Office Excel 2007.
  • You set the value of the ScreenUpdating property to False to turn off screen updating.
  • You programmatically print or print preview a file.
In this scenario, either a runtime error occurs or a runtime error occurs and then Office Excel 2007 crashes.

RESOLUTION

To fix this issue, apply the hotfix package from KB article 978399 and then enable this hotfix package. To do this, follow these steps:
  1. Apply the hotfix package from KB article 978399. For more information about the hotfix, click the following article number to view the article in the Microsoft Knowledge Base:
    978399  (http://kbalertz.com/Feedback.aspx?kbNumber=978399/ ) Description of the Office Excel 2007 hotfix package (Excel-x-none.msp, Graph-x-none.msp, Xlconv-x-none.msp, Xlview-x-none.msp): February 23, 2010
  2. Enable the hotfix package.

    To have us enable the hotfix package for you, go to the "Fix it for me" section. If you prefer to fix this problem yourself, go to the "Let me fix it myself" section.

    Fix it for me


    To fix this problem automatically, click the Fix it button or link. Then click Run in the File Download dialog box, and follow the steps in the Fix it wizard.


    Fix this problem
    Microsoft Fix it 50728


    Notes
    • This wizard may be in English only. However, the automatic fix also works for other language versions of Windows.
    • If you are not on the computer that has the problem, save the Fix it solution to a flash drive or a CD and then run it on the computer that has the problem.

    Then, go to the "Did this fix the problem?" section.



    Let me fix it myself

    To do this, follow these steps:
    1. In Windows Vista, click Start
      Collapse this imageExpand this image
      the Start button
      , type regedit in the Start Search box, and then press ENTER.

      Collapse this imageExpand this image
      User Account Control permission
      If you are prompted for an administrator password, type the password. If you are prompted for confirmation, provide confirmation.

      In Windows XP, click Start, click Run, type regedit in the Open box, and then click OK.
    2. Locate and then click the following registry subkey:
      HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Options\
    3. On the Edit menu, point to New, and then click DWORD Value.
    4. Type ResetWnxCurInPrint, and then press ENTER.
    5. Right-click ResetWnxCurInPrint, and then click Modify.
    6. In the Value data box, type 1, and then click OK.
    7. Exit Registry Editor.

Did this fix the problem?

  • Check whether the problem is fixed. If the problem is fixed, you are finished with this section. If the problem is not fixed, you can contact support (http://support.microsoft.com/contactus) .
  • We would appreciate your feedback. To provide feedback or to report any issues with this solution, please leave a comment on the "Fix it for me (http://blogs.technet.com/fixit4me/) " blog or send us an email (mailto:fixit4me@microsoft.com?Subject=KB) message.

APPLIES TO
  • Microsoft Office Excel 2007
Keywords: 
kbqfe kbexpertiseinter kbsurveynew kbprb kbfixme kbmsifixme KB979370
       

Community Feedback System

Very often, it takes hours to solve a problem. Very often, you've looked high and low, and have tried a lot of solutions. When you finally found it, chances are, it was because someone else helped you. Here's your chance to give back. Use our community feedback tool to let others know what worked for you and what didn't.

Please also understand that the community feedback system is not warranted to be correct, it's simply a system that we've built to let people try and help each other. If something in a feedback response doesn't make sense to you, or you're not comfortable making changes that the feedback talks about (like registry edits), please consult a professional.

Thank you for using kbAlertz.com Feedback System.

-- Scott Cate