Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Description of the Office Excel 2007 hotfix package (excel-x-none.msp, graph-x-none.msp, xlconv-x-none.msp): August 31, 2010


View products that this article applies to.

Summary

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

↑ Back to the top


Introduction

Issues that this hotfix package fixes

  • Consider the following scenario:
    • You create a stack chart in an Excel workbook by using Office Excel 2003.
    • You adjust the chart position, which causes the position of the legends to change.
    • You save the workbook in Office Excel 2003.
    • You open the workbook in Office Excel 2007.

    In this scenario, the order of the legends may be reversed.

  • On a computer that is running Office Excel 2007, you click a hyperlink that links to an Office Excel workbook (.xlsx format). In this situation, the Office Excel 2007 window and the workbook window are not maximized when the workbook is opened.

  • In Office Excel 2007, if an INDIRECT() function contains an array formula that uses the unary operator �-� or �%�, Office Excel 2007 does not calculate the formula correctly. This issue may also occur on other volatile functions such as RAND() and RANDBETWEEN().

  • Consider the following scenario:
    • You add a hierarchy to an�Online Analytical Processing�(OLAP) Pivot Table in an Office Excel workbook. Then, you apply a filter to the Pivot Table.
    • You remove the hierarchy from the Pivot Table. Then, you add another hierarchy�to the Pivot Table and hide one of its levels.
    • You save and close the workbook.
    • You try to open the workbook by using Office Excel 2007.

    In this scenario, Office Excel 2007 crashes.

  • Consider the following scenario:
    • In an Office Excel 2007 workbook that contains a chart, you change the zoom value to a value other than 100%.
    • You select the cell range that intersects the chart.
    • You click the Paste drop-down menu, you select As Picture, and then you click Copy as Picture.
    • On the Copy Picture dialog box, you select As shown when printed.
    • You paste the chart.

    In this scenario, the position and the size of the pasted chart are incorrect.

  • Consider the following scenario:
    • You install the hotfix package that is described in Microsoft Knowledge Base article 981046 on a computer that is running Office Excel 2007.
    • You have an Office Excel workbook in the Excel 97- Excel 2003 Binary format (BIFF8).
    • The workbook contains a chart that has the vary colors option enabled.
    • A data point that uses an exceptional formatting is not on the chart.
    • You open the workbook by using Office Excel 2007.

    In this scenario, the colors in the chart may be incorrect.

  • When you import a text file in Office Excel 2007, certain values are not recognized as the numeric value. This issue occurs if the following conditions are true:
    • The decimal separator in the text file is different from the decimal separator that is defined in the Regional Settings.
    • The value is smaller than one.
    • The value does not have a leading �0�.

  • Consider the following scenario:
    • In Office Excel 2007, you hide more than half of the columns in the worksheet. Additionally, you also hide the last column of the worksheet.
    • You copy data from another worksheet that is opened in another instance of Office Excel 2007.
    • You paste the data into the worksheet that has hidden columns.

    In this scenario, hidden column are visible unexpectedly.

  • Consider the following scenario:
    • You have two Office Excel workbooks (workbook A and workbook B) that are stored on network share.
    • You open workbook A by using Office Excel 2007.
    • You double-click a cell that links to a cell in workbook B.
    • Office Excel 2007 opens workbook B.

    In this scenario, the cell in workbook B that links to workbook A is not selected.

  • Consider the following scenario:
    • In Office Excel 2007, you open an Office Excel 5.0/95 workbook ( .xls format) that contains a chart. The source data of the chart is in an external text file.
    • You save the workbook in .xlsx format. Then you close Office Excel 2007.
    • You move the .xlsx workbook to another location.
    • You open the .xlsx workbook by using Office Excel 2007.

    In this scenario, the chart does not display.

  • After you right-click a Microsoft Graph Chart object and select Open from Chart Object in PowerPoint 2007, the size of the graph chart reduces.

↑ Back to the top


More information

Hotfix information

A supported hotfix is available from Microsoft. However, this hotfix is intended to resolve 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 website: 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:
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 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
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Office-kb2276477-fullfile-x86-glb.exe12.0.6545.500018,752,56014-Aug-201004:09x86

Microsoft Windows Installer .msp file information
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Excel-x-none.mspNot Applicable8,993,28013-Aug-201017:54Not Applicable
Graph-x-none.mspNot Applicable1,500,67213-Aug-201017:54Not Applicable
Xlconv-x-none.mspNot Applicable8,182,27213-Aug-201017:54Not Applicable


Excel-x-none.msp information
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Excel.exe12.0.6545.500018,354,02413-Aug-201013:06x86

Graph-x-none.msp information
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Graph.exe12.0.6545.50002,532,73611-Aug-201012:49x86

Xlconv-x-none.msp information
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatform
Excelcnv.exe12.0.6545.500015,130,47211-Aug-201021:47x86

↑ Back to the top


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

↑ Back to the top


Keywords: KB2276477, kbhotfixrollup, kbqfe, kbautohotfix, kbhotfixserver, kbexpertiseinter, kbsurveynew

↑ Back to the top

Article Info
Article ID : 2276477
Revision : 2
Created on : 9/9/2010
Published on : 9/9/2010
Exists online : False
Views : 267