Description of the Office Excel 2007 hotfix package (Excel-x-none.msp, Graph-x-none.msp, Xlconv-x-none.msp, Xlview-x-none.msp): April 27, 2010

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

Issues that this hotfix package fixes

• You change the key columns of a dimension from multiple to unique in an Analysis Services database cube. When you expand the hierarchy level gradually in the Microsoft Office Excel 2007 workbooks that use the dimension, the workbooks are corrupted.
  
  
• Consider the following scenario:
  • You create a PivotTable based on an OLAP data source.
  • After changes are made to the cube, you open the book and refresh the PivotTable.
  • You save and close the book.
  • The next time that you open the book, you receive "Unreadable Content" errors, and after recovery the PivotTable is no longer functioning.
  
  
  
• Consider the following scenario:
  • You have an embedded Office Excel worksheet object in another application on a computer that is running Windows Vista or Windows 7. The Office Excel worksheet object looks correct at this point.
  • You open and then edit the Excel worksheet object in Office Excel 2007.
  • You save the Office Excel worksheet object.
  • You close the Office Excel worksheet object and back to the host application.
  In this scenario, the bottom or the side of the Office Excel Worksheet object is clipped.
  
  
• You have a chart that contains manually positioned data labels for series that are not displayed in Office Excel 2007. When you try to save the file in the .xls format, Office Excel 2007 crashes.
  
  
• You have a computer that has 2007 Microsoft Office system Service Pack 1 installed. You use the INDEX function as part of an array formula in an Office Excel 2007 worksheet. When the formula is recalculated, Office Excel 2007 crashes. This problem occurs because the first argument in the INDEX function is not recalculated.
• You cannot bypass the automatically running macro in an Office Excel 2007 workbook by keeping the SHIFT key pressed. This problem occurs when the following conditions are true:
  • The workbook is in a UNC path or in a network drive.
  • The workbook is opened from either the file open dialog box or from the recent file list.
  • The workbook contains an Auto_Open procedure in a module, or a Workbook_Open sub procedure in the workbook object.
• You use the Picture (Windows Metafile) feature or the Picture (Enhanced Metafile) feature to paste some cells from Office Excel 2007 to Office Word 2007. In this situation, the source formatting is retained in the destination. The source formatting includes the following:
  • Gridlines
  • Comment indicators
  • Auto-filter buttons
  • Text color
  • Cell color
• Consider the following scenario:
  • You have an Office Excel 2007 workbook that contains a camera object or a picture link.
  • You insert a text box to the workbook.
  • You type characters into the text box.
  In this scenario, a delay occurs in displaying the typed characters.
  
  
• In Office Excel 2007, you open a workbook that was created in Office Excel 2003 or an earlier version. When you copy and then paste a chart from the workbook to an Office Word document, the pasted chart may be displayed incorrectly. This problem is more likely to occur when the chart size is small.
  
  
• Consider the following scenario:
  • You have a column in an Office Excel 2007 worksheet that contains spaces and blank cells.
  • You enable filtering on the column.
  • You select more than two criteria. One of the criteria is (Blanks).
  In this scenario, the cells that contain spaces are not displayed as expected.
  
  
• When you programmatically hide or unhide rows in an Office Excel 2007 workbook, the performance decreases. This problem occurs after you apply 2007 Microsoft Office system Service Pack 2.
  
  
• You have an Office Excel 2007 worksheet that contains a data table that references a formula in the same worksheet. The worksheet is copied to a new worksheet when Office Excel 2007 is in manual calculation mode. In the new worksheet, the source data of the formula that the data table depends on is changed. If you press F9 or SHIFT+F9, the data table is not calculated as expected.
  
  
• You have an Office Excel 2007 workbook that contains two or more formulas that indirectly depend on one other. For example, the formulas contain the VLOOKUP function and are included in the area that is referenced in the same VLOOKUP function. When the workbook is calculated, Office Excel 2007 may stop responding. This problem occurs when one of the following conditions is true:
  • The Enable multi-threaded calculation check box is not selected in Office Excel 2007.
  • The Range.Calculate method is used on the area that is referenced in the formulas.
• Consider the following scenario:
  • You have an .xlsx file or an .xlsb file that contains an external link to a document.
  • You click to clear the Save external link values check box.
  • You save the file.
  In this scenario, the content of the external document is stored in the file unexpectedly.
  
  
• Consider the following scenario:
  • You have a workbook that contains a pie chart in Office Excel 2007.
  • The Data Labels feature of the chart is set to Outside End.
  • You edit a data label for the chart.
  • You save the workbook in the Excel 97-2003 Workbook (*.xls) format, and then you close the workbook.
  • You reopen the workbook.
  In this scenario, the data label that you edited is displayed inside the chart.
  
  
• Consider the following scenario:
  • You paste a chart from an Office Excel 2007 workbook to a Microsoft Office Word 2007 document as a link. The chart in Office Excel 2007 is off-screen.
  • You right-click the object in Office Word 2007, point to Linked Worksheet Object, and then click Open Link to open the object in Excel 2007.
  • You right-click the object in Office Word 2007, and then click Update Link.
  In this scenario, the chart is not displayed in Office Word 2007.
  
  
• You cannot share an Office Excel 2007 workbook after you apply security update 978382.
  
  For more information about security update 978382, click the following article number to view the article in the Microsoft Knowledge Base:
  978382� MS10-017: Description of the security update for Excel 2007: March 9, 2010

Hotfix information

A supported hotfix is available from Microsoft. However, this hotfix is intended to correct only the problems that are described in this article. Apply this hotfix only to systems that are experiencing the problems 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: Note 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:

Restart requirement

You do not 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 correct the issues that are 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



Microsoft Windows Installer .msp file information



Excel-x-none.msp information

Graph-x-none.msp information

Xlconv-x-none.msp information

Xlview-x-none.msp information

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