Summary

This article describes the Microsoft Office Excel 2007 issues that are fixed in the Office Excel 2007 hotfix package that is dated June 29, 2010.

This article describes the following items about the hotfix package:

  • The issues that the hotfix package fixes.

  • The prerequisites for installing the hotfix package.

  • Whether you must restart the computer after you install the hotfix package.

  • Whether the hotfix package is replaced by any other hotfix packages.

  • Whether you must make any registry changes.

  • The files that the hotfix package contains.

INTRODUCTION

Issues that this hotfix package fixes

  • Consider the following scenario:

    • You install Microsoft Office Excel 2007 on a computer.

    • You apply the hotfix package that is described in Microsoft Knowledge Base (KB) article 973933 to the computer.

    • You create a Remote Desktop Protocol (RDP) connection to the computer.

    • You open an Office Excel 2007 workbook on the computer through this RDP connection.

    • You copy some cell from the Office Excel 2007 workbook.

    In this scenario, Office Excel 2007 crashes when you paste the cell that you copied into the same workbook by using the Paste Picture Link command.

  • Office Excel 2007 crashes when you open certain Excel workbooks.

  • Consider the following scenario:

    • User A opens an Office Excel 2007 workbook that is stored on a network share.

    • User B opens the same workbook as read-only.

    • User A makes changes to the workbook and then saves the workbook.

    In this scenario, User B cannot see the changes that User A saved when User B clicks Update file on the Quick Access Toolbar (QAT) in Office Excel 2007.

  • You apply 2007 Office Suite Service Pack 2 (SP2) on a computer that has Office Excel 2007 installed. When you paste an ActiveX object into an embedded Office Excel 2007 worksheet, Office Excel 2007 crashes.

  • You press CTRL+ALT+SHIFT+F9 to perform a full recalculation in an Office Excel 2007 workbook. And then, you save the workbook. When you open the workbook again, you may receive the following error message:

    Excel found unreadable content in 'FileName'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes.

  • When you open an Excel workbook that uses the LOOKUP function and then you press F9 two times, Office Excel 2007 may stop responding.

  • Consider the following scenario:

    • You use Microsoft Visual Basic for Applications (VBA) that is in Office Excel 2007 to copy worksheets from an Office Excel workbook to a new Office Excel workbook.

    • You save the new workbook.

    In this scenario, you may receive the following error message when you open the new workbook again:

    Excel found unreadable content in 'FileName'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes.

  • Conditional Formatting rules that highlight cells that are below 2 or 3 standard deviations do not work correctly in Office Excel 2007.

  • Consider the following scenario:

    • You have an Office Excel workbook that contains a chart and a shape. The height of the shape is 0.

    • You right-click the chart and select Move Chart, and then you select New sheet in the Move Chart dialog box.

    In this scenario, Office Excel 2007 crashes when you click OK in the Move Chart dialog box.

  • When you open a workbook that has an Excel 4.0 format in Office Excel 2007, you find that the chart is displayed incorrectly. This issue occurs when the data resource for a chart of the workbook is in another .dat file.

  • On a computer that is running Windows 7, you may receive the following message when you save an Office Excel 2007 workbook:

    Your changes could not be saved to 'FileName' because of a sharing violation. Try saving to a different file.

  • You apply a conditional formatting rule on a cell in Office Excel 2007. When you use the context menu in Excel to filter the data in the sheet by the cell color, by the font color or by the icon, Office Excel 2007 crashes.

  • After you press F9 to calculate the Office Excel worksheet that contains an array formula, Office Excel 2007 stops responding if the array formula contains a circular reference.

More Information

Hotfix information

A supported hotfix is available from Microsoft. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing the problem described in this article. This hotfix might receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next software update that contains this hotfix.If the hotfix is available for download, there is a "Hotfix download available" section at the top of this Knowledge Base article. If this section does not appear, contact Microsoft Customer Service and Support to obtain the hotfix. Note If additional issues occur or if any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft Web site:

http://support.microsoft.com/contactus/?ws=supportNote The "Hotfix download available" form displays the languages for which the hotfix is available. If you do not see your language, it is because a hotfix is not available for that language.

Prerequisites

You must have 2007 Microsoft Office suite Service Pack 2 or 2007 Microsoft Office suite Service Pack 1 installed to apply this hotfix package. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

949585 How to obtain the latest service pack for the 2007 Office suite

Restart requirement

You may have to restart the computer after you apply this hotfix.

Hotfix replacement information

This hotfix does not replace a previously released hotfix.

Registry information

To use one of the hotfixes in this package, you do not have to make any changes to the registry.

File information

This hotfix may not contain all the files that you must have to fully update a product to the latest build. This hotfix contains only the files that you must have to resolve the issue that is listed in this article.The global version of this hotfix package uses a Microsoft Windows Installer package to install the hotfix package. The dates and the times for these files are listed in Coordinated Universal Time (UTC) in the following table. When you view the file information, the date is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.Download information

File name

File version

File size

Date

Time

Platform

Office-kb983314-fullfile-x86-glb.exe

12.0.6539.5001

18,822,272

19-Jun-2010

04:24

x86

Microsoft Windows Installer .msp file information

File name

File version

File size

Date

Time

Platform

Excel-x-none.msp

Not Applicable

9,126,912

18-Jun-2010

18:55

Not Applicable

Graph-x-none.msp

Not Applicable

1,799,680

18-Jun-2010

18:55

Not Applicable

Xlconv-x-none.msp

Not Applicable

8,478,208

18-Jun-2010

18:55

Not Applicable

Excel-x-none.msp information

File name

File version

File size

Date

Time

Platform

Excel.exe.manifest

Not applicable

791

16-Jun-2010

01:53

Not applicable

Excel.exe

12.0.6539.5001

18,351,976

18-Jun-2010

22:33

x86

Xlcall32.dll

12.0.6500.5000

10,120

26-Feb-2009

13:09

x86

Graph-x-none.msp information

File name

File version

File size

Date

Time

Platform

Graph.exe

12.0.6539.5000

2,532,736

08-Jun-2010

23:37

x86

Xlconv-x-none.msp information

File name

File version

File size

Date

Time

Platform

Excelcnv.exe

12.0.6539.5001

15,131,496

16-Jun-2010

02:07

x86

Excelcnvpxy.dll

12.0.6500.5000

71,520

26-Feb-2009

18:43

x86

References

For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:

824684 Description of the standard terminology that is used to describe Microsoft software updates

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.