Applies ToOffice 2007

Summary

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

INTRODUCTION

Issues that this hotfix package fixes

  • Consider the following scenario:

    • In an Excel worksheet, the data range for a chart is in the non-ascending order.

    • The data series in the chart have the custom error bar.

    • You change the horizontal axis to a date axis.

    In this scenario, the error bar values are drawn to the wrong data points in the chart.

  • In Excel 2007, when you try to use the programming method to retrieve a value in a surface chart, you receive the following error message:

    System Error &H80010108 (-2147417848). The object invoked has disconnected from its clients.

  • In an Excel worksheet, a Scatter chart contains data markers. You set the "Marker Type" to "Built-in" and you use a picture or a texture to fill the markers. In this case, when you use print preview to view the Excel worksheet and you try to print the worksheet in black-and-white, the data markers are still in color unexpectedly.

  • An Area chart that use date axis is unreadable in Excel 2007 when the date range for the chart contains an empty cell.

  • In an Excel worksheet, a stacked Area chart contains two data series and a secondary axis. In this case, when you set the minimum value for the horizontal axis to a fixed value, the second data series is plotted unexpectedly outside the plot area.

  • In Excel 2007, you customize the formatting of a data point in a stacked chart. When you show the series lines in the chart, the data point disappears unexpectedly.

  • When you paste an Excel chart object as a link in Word 2007, PowerPoint 2007 or OneNote 2007, some chart content displayed outside the plot area.This problem occurs when the following conditions are true:

    • You applied the hotfix package that is discussed Microsoft Knowledge Base (KB) article 972559.

    • The value of the AliasedDMToMetafilePlus registry entry was set to 1 under the following registry subkey:

      HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Common\Charting

    • You modify any of the axis limits to be less than the ture data range for the chart

  • The tooltip displays incorrect information for a data point in a chart that is in Excel 2007.

  • You delete a data series in a stacked chart that is in an Excel 2003 file. When you reopen the Excel 2003 file in Excel 2007, the legend entry for the deleted data series still appears in a stacked chart.

  • The connector between two shapes is disconnected when one of these shapes is grouped with a third shape and all these shapes are moved together.

  • In an Office file, you insert a pyramid SmartArt graphic and you resize one of the segments in the pyramid. When you save and reopen the file, the resized pyramid segment is displayed incorrectly as a triangle.

  • The dates are shown incorrectly in the date axis of a chart.

  • You install the 2007 Office Cumulative Update for December 2009 that is discussed in KB article 978223. You print an Office file by using a PostScript printer. However, the text and the graphics in the file are printed incorrectly in the print output.

  • In Excel 2007 SP2, you cannot see text in a Text Box when the text box contains multiple columns.

  • Consider the following scenario:

    • There is a stacked Area chart in an Excel 2007 worksheet.

    • You select the Maximum axis value option under the Horizontal axis crosses section in the Format Axis dialog box. Note This is to specify that the horizontal axis crosses the vertical axis at the highest value on the axis.

    In this scenario, the labels for the horizontal axis are moved to the opposite side of the chart. However, the area is unexpectedly filled from the bottom to the top of the chart.

  • In an Excel 2007 workbook, there is a Text Box that contains spaces. When you print or print preview the workbook, the amount of pages that is printeddiffers from the amount of pages when you view the workbook in the Page Break Preview.This problem occurs when one of the following conditions is true:

    • You are running the Japanese version of Excel 2007.

    • You are running the English version of Excel 2007, and you set Japanese as the primary editing language.

  • You use Excel 2007 to open an Excel chart object that is created in Excel 2003. When you edit the chart in Excel 2007, the size of the chart becomes larger unexpectedly.

  • In an Office PowerPoint presentation slide, an Office Excel chart is inserted as an embedded object. When you double-click the chart to open it, you receive the following error message:

    The server application, source file, or item can't be found, or returned an unknown error. You may need to reinstall the server application.

    Additionally, both Excel 2007 and PowerPoint 2007 stop responding.

  • If multiple presentations that contain charts are used at the same time, PowerPoint 2007 may crash.

  • If you change the fill color of a PivotChart in a chart template in Excel 2007 and then apply this template to a new PivotChart, the fill color is lost and the new PivotChart uses the automatic setting for the fill color.Note This issue occurs after the 2007 Microsoft Office Suite Service Pack 2 is installed.

More Information

Hotfix information

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

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

File name

File version

File size

Date

Time

Platform

Office-kb981047-fullfile-x86-glb.exe

12.0.6535.5000

10,520,864

10-Apr-2010

04:00

x86

Microsoft Windows Installer .msp file information

File name

File version

File size

Date

Time

Platform

Oart-x-none.msp

Not Applicable

8,082,944

09-Apr-2010

15:18

Not Applicable

Oartconv-x-none.msp

Not Applicable

4,269,568

09-Apr-2010

15:18

Not Applicable

Oartconv-x-none.msp information

File name

File version

File size

Date

Time

Platform

Oartconv.dll

12.0.6535.5000

8,571,256

09-Apr-2010

19:27

x86

Oart-x-none.msp file information

File name

File version

File size

Date

Time

Platform

Oart.dll

12.0.6535.5000

16,142,184

09-Apr-2010

19:27

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.