Summary

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

INTRODUCTION

Issues that this hotfix package fixes

  • You have a Office Excel 2007 file in a Microsoft Office SharePoint document library. This document library tracks major versions and requires check-out for documents in the library. When you try to save the file, Office Excel 2007 closes without saving changes. This problem occurs when the document is checked out by another user.

  • You have a computer that has 2007 Microsoft Office suite Service Pack 2 installed. Then, you programmatically copy a cell range that contains charts that are in the invisible area in an Office Excel 2007 worksheet. When you use the Paste Special command to paste the cell range, the pasted cell range contains no chart.

  • In Office Excel 2007, you open a Microsoft Office Excel Workbook that was created in Microsoft Office Excel 2003 or earlier versions. In this case, the Name Conflict dialog box prompts you to provide an alternative name to open the file. Additionally, you cannot skip or cancel this dialog box.

  • You have grouped or filtered cells that contain a chart or a SmartArt object in Office Excel 2007. When you delete the first row that is under the grouped or filtered cells, the chart or the SmartArt object is deleted.

  • You use a Web browser control that is embedded in an Office Excel 2007 worksheet to access a Web site in Internet Explorer 8. When you click a link on the Web site, the Print dialog box appears.

  • You use a Microsoft XPS Document Writer printer to print certain Office Excel 2007 workbooks that contain list box controls. In this case, Office Excel 2007 crashes.

  • You use the Unprotect method to unprotect an inactive worksheet in Office Excel 2007. In this case, the controls in the inactive sheet are displayed in other worksheets. This problem occurs after you apply one of following updates:

    • 970941 Description of the Excel 2007 hotfix package (Excel.msp, Oart.msp): June 30, 2009

    • 971787 Description of the 2007 Office system hotfix package (Excel.msp, Xlconv.msp): June 30, 2009

    • 973593 MS09-067: Description of the security update for Excel 2007: November 10, 2009

  • You save an Office Excel 2007 file in the Excel 97- Excel 2003 Binary file format (BIFF8). In this case, Office Excel 2007 crashes. This problem occurs when the following conditions are true:

    • The last formula on the global calculation chain is the only formula on the worksheet.

    • You have at least one formula on another worksheet.

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

Known issues

SymptomAfter you install this update, you may receive an error message that resembles the following when you try to save a shared workbook:

The file is no longer shared

This problem can occur if the file is saved to a network location, and then configured as a shared workbook. ResolutionTo resolve this problem, install security update 982308. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

982308 MS10-038 and MS10-036: Description of the security update for Excel 2007: June 8, 2010WorkaroundTo work around this problem, use either of the following methods:

  • To avoid this problem when you create a workbook that must be shared, turn on the shared workbook option before you save the workbook to a network share.

  • If the problem has already occurred, follow these steps:

    1. Open the shared workbook, and then save it to a local drive.

    2. Turn on the shared workbook option.

    3. Save the workbook on the network share.

For more information about how to share a workbook, visit the following Microsoft Web page:

http://office.microsoft.com/en-us/excel/HP100968331033.aspx#ShareWorkbook

More Information

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:

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

File name

File version

File size

Date

Time

Platform

Office-kb978399-fullfile-x86-glb.exe

12.0.6529.5000

25,378,048

04-Feb-2010

12:36

x86

Microsoft Windows Installer .msp file information

File name

File version

File size

Date

Time

Platform

Excel-x-none.msp

Not Applicable

9,127,936

04-Feb-2010

00:50

Not Applicable

Graph-x-none.msp

Not Applicable

1,799,168

04-Feb-2010

00:50

Not Applicable

Xlconv-x-none.msp

Not Applicable

8,480,768

04-Feb-2010

00:50

Not Applicable

Xlview-x-none.msp

Not Applicable

7,326,208

04-Feb-2010

00:50

Not Applicable

Excel-x-none.msp information

File name

File version

File size

Date

Time

Platform

Excel.exe.manifest

Not applicable

791

03-Feb-2010

02:41

Not applicable

Excel.exe

12.0.6529.5000

18,348,392

04-Feb-2010

04:21

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.6529.5000

2,532,224

03-Feb-2010

01:22

x86

Xlconv-x-none.msp information

File name

File version

File size

Date

Time

Platform

Excelcnv.exe

12.0.6529.5000

15,126,888

03-Feb-2010

03:03

x86

Excelcnvpxy.dll

12.0.6500.5000

71,520

26-Feb-2009

18:43

x86

Xlview-x-none.msp information

File name

File version

File size

Date

Time

Platform

Xlview.exe

12.0.6529.5000

13,231,992

02-Feb-2010

19:11

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.