This article has been archived. It is offered "as is" and will no longer be updated.
This article describes the 2007 Microsoft Office system issues that are fixed in the hotfix package that is dated June 30, 2009.
Issues that this hotfix package fixes
In Excel 2007, you cannot copy noncontiguous rows or columns from a large grid and then paste them into a small grid.
You edit and then save an Excel 2003 file that contains AutoShapes in Excel 2007. When you re-open the file in Excel 2003, the AutoShapes are automatically converted to Edit Mode. Additionally, if the AutoShapes were transparent, the transparency setting is lost and the corresponding text areas become invisible.
Consider the following scenario:
You add the registry keys that are described in KB 927009.
You open some Excel workbooks in Internet Explorer 7.0.
You click a sheet in an inactive browser.
In this scenario, Excel crashes.
You have a 2007 Office application that contains both an embedded object and a picture. When you select and then programmatically copy the picture by using the Copy method, you receive the following error message:
Error: Copy method of picture class failed.
When you print a 2007 Excel workbook with the Entire workbook option enabled, the camera object or the paste link picture object does not print correctly.
This problem occurs on any printer.
This problem also occurs when you preview multiple sheets.
This problem does not occur if you print a single sheet.
When you try to re-open an Excel 2007 workbook that contains a smart tag with a string longer than 255 characters, you receive a repair warning. Additionally, after the workbook is repaired, the string is truncated to 255 characters. This problem occurs when the smart tag information is embedded in the workbook.
When you save multiple files in Excel 2007 and then call the worksheet.unprotect function in the Workbook_BeforeSave event, you receive the following error message:
Method 'Unprotect' of object '_Worksheet' failed
You edit an Excel 2003 file that contains user-defined names with formulas in Excel 2007. After you save the file, the formulas for the defined names are lost.
This problem occurs when the formulas contain Analysis ToolPak functions and the file is saved in an earlier format.
Consider the following scenario:
You save an Excel 2007 file that has an Excel 4.0 macro sheet in the .xlsb format, the .xlsm format, or the .xltm format.
You close and then re-open the file.
You set a password to protect the file by selecting Protect structure and Windows or Protect and share Workbook.
You save the changes and then close the file.
You open the file again.
In this scenario, you receive the following error message:
Cannot insert Excel 4.0 macros in a restricted or password protected workbook.
After you click OK to recover the file, you receive the same error message several times. Finally, you receive the following error message:
The workbook cannot be opened or repaired by Microsoft Excel because it is corrupt.
973105 AutoShapes are automatically converted to Edit mode when you open an Excel 2003 workbook
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.
You must have 2007 Microsoft Office suite Service Pack 1 or 2007 Microsoft Office suite Service Pack 2 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
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.
To use one of the hotfixes in this package, you do not have to make any changes to the registry.
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 P1 version of this P2 uses a Microsoft Windows Installer package to install the P2. 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.
Microsoft Windows Installer .msp file information
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