Summary

This article describes the Microsoft Office Excel 2010 issue that is fixed in the hotfix package that is dated October 25, 2011.

INTRODUCTION

Issue that this hotfix package fixes

  • You have an Excel workbook that contains a sparkline or a slicer. You open the workbook in Excel 2010, and then you save the workbook as a .pdf file. In this case, the tag of the sparkline or the slicer is generated as <Span> incorrectly.Note The tag of the sparkline or the slicer should be generated as <Figure> or <Diagram>.

  • Consider the following scenario:

    • You open an Excel workbook that has a Combo Box form control or a List Box form control in Excel 2010. You use a macro to define a change method in the Combo Box form control or in the List Box form control in Macro.

    • You click to select the item in the Combo Box form control or in the List Box form control that is selected by default.

    In this scenario, the change method is called incorrectly.Note This issue does not occur in Microsoft Office Excel 2007 and Microsoft Office Excel 2003.

  • Consider the following scenario:

    • You open an Excel workbook in Excel 2010 that has a Visual Studio Tools for Office (VSTO) application installed.

    • The VSTO application uses the FreezePanes property to freeze a pane in the worksheet.

    • You use the VSTO application to add a button close to the pane. When you click the button, a message box appears.

    • You scroll down the worksheet so that the button is no longer displayed.

    • You scroll up the worksheet.

    In this scenario, the button disappears.

  • Assume that you apply border settings to cells in a worksheet in Excel 2010. When you try to change the settings of the inner borders, the new border settings cannot be applied.

  • When you use the vbCrLf field for the text of a Form control in Excel 2010, an additional line is displayed. For example, you run the following macro in Excel 2010:

    Sub Change_Caption()   ThisWorkbook.Worksheets(1).Shapes("Button 1").Select   Selection.Characters.Text = "aaa" & vbCrLf & "bbb"End Sub

    In this example, the following text is displayed:

    aaabbb

  • When you try to insert an Excel spreadsheet in Word, PowerPoint, or another application, you receive the following error message:

    The program used to create this object is Excel. That program is either not installed on your computer or it is not responding. To edit this object, install Excel or ensure that any dialog boxes in Excel are closed.

    This issue occurs when the following conditions are true:

    • You configure Excel 2010 to open all the files in a specified network folder when Excel 2010 starts.

    • There is an .xslt file in the specified network folder.

  • Consider the following scenario:

    • You insert a block arrow that points to the right side of the screen in an Excel 2003 workbook.

    • You set the rotation of the arrow to 45, 135, 225, or 315 degree. Then, you flip the arrow vertically or horizontally.

    • You save the workbook in Excel 2003.

    • You open the workbook in Excel 2010.In this scenario, the arrow is displayed in a different way to the way that it is displayed in Excel 2003.

  • Consider the following scenario:

    • In Excel 2010, you save an Excel workbook as an Excel template (*.xltx) in the default template folder.

    • You use the template to create a new Excel workbook.

    In this scenario, the file name extension of the Excel workbook is .xltx1. Additionally, if you send the workbook by using the Send as Attachment feature, the attachment cannot be opened in Excel.

  • Assume that you have a text box that contains some Double-Byte Character Set (DBCS) text in an Excel workbook that has an .xls file name extension. You save the workbook in Excel 2010. However, if you then open the workbook in Excel 2003, some text formatting is lost.

  • Consider the following scenario:

    • You have shared formulas and conditional formats in an Excel 2010 worksheet.

    • You select the Manual option from the Calculation Options menu on the Formulas tab.

    • You perform the initial calculation in the worksheet.

    In this scenario, some cells may not be calculated again after the initial calculation.

  • 2596575  ActiveX control is changed after you print preview, print, or save a workbook in Excel 2010

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 website:

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 Microsoft Office 2010 or Microsoft Office 2010 Service Pack 1 (SP1) installed to apply this hotfix package. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

2510690 List of all Office 2010 SP1 packages

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 the hotfix 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 English 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.x86Download information

File name

File version

File size

Date

Time

Excel2010-kb2596494-fullfile-x86-glb.exe

14.0.6112.5000

55,797,224

17-Oct-11

1:50

Microsoft Windows Installer .msp file information

File name

File version

File size

Date

Time

Excel-x-none.msp

Not Applicable

66,426,368

16-Oct-11

14:50

After the hotfix is installed, the global version of this hotfix has the file attributes, or a later version of the file attributes, that are listed in the following table: Excel-x-none.msp file information

File name

File version

File size

Date

Time

Excel.exe

14.0.6112.5000

20,375,904

16-Oct-11

11:12

Excelcnv.exe

14.0.6112.5000

17,815,904

6-Oct-11

16:09

Xlicons.exe

14.0.6009.1000

1,479,520

1-Sep-11

16:35

x64Download information

File name

File version

File size

Date

Time

Excel2010-kb2596494-fullfile-x64-glb.exe

14.0.6112.5000

56,268,984

17-Oct-11

0:35

Microsoft Windows Installer .msp file information

File name

File version

File size

Date

Time

Excel-x-none.msp

Not Applicable

65,383,936

16-Oct-11

14:57

After the hotfix is installed, the global version of this hotfix has the file attributes, or a later version of the file attributes, that are listed in the following table:

File name

File version

File size

Date

Time

Excel.exe

14.0.6112.5000

27,619,680

16-Oct-11

11:14

Excelcnv.exe

14.0.6112.5000

25,016,160

6-Oct-11

16:12

Xlicons.exe

14.0.6009.1000

1,479,520

1-Sep-11

16:35

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.