Microsoft KB Archive/235862

From BetaArchive Wiki
Knowledge Base


PPT97: Group Object Containing Excel Object Changes Size When Excel Object Is Opened Via OleFormat.DoVerb

Article ID: 235862

Article Last Modified on 10/18/2005



APPLIES TO

  • Microsoft PowerPoint 97 Standard Edition
  • Microsoft Excel 97 Standard Edition



This article was previously published under Q235862


SYMPTOMS

If you create an object group that contains an Excel chart object and another object in a PowerPoint 97 presentation and you run a macro that uses the DoVerb method to open the Excel chart object, the size of the group object in PowerPoint changes.


STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was corrected in Microsoft Office 2000 SR-1/SR-1a.

MORE INFORMATION

Important Notes

  1. If you insert an object, choose Create from the File menu, and select an Excel workbook in which a chartsheet is the active sheet. The Excel object will not resize when you activate it with Open mode. You invoke Open mode by right-clicking on the Excel object and selecting Open [Worksheeet/Chart] Object.
  2. If you insert an object, choose Create from the File menu, and select an Excel workbook in which a worksheet is the active sheet, the chartsheet will be rendered the size of the PowerPoint slide if you toggle between the worksheet and a chartsheet while in open mode. This also occurs when you copy and paste to embed an object. This behavior is consistent with behavior observed with Excel 97 SR-2 and PowerPoint 97 SR-2.
  3. If you insert an object, choose Create from File, select an Excel workbook in which a worksheet is the active sheet, and the cell range is such that the maximum size limits for a Windows metafile are exceeded, the metafile will not show the entire worksheet. This is a WMF limit and cannot be changed.



Additional query words: xl97 ppt97 oleformat doverb resize object activate

Keywords: kbbug kbqfe kbpending kbhotfixserver KB235862