Microsoft KB Archive/287117

= Unable to copy a sheet with a PivotTable to a new workbook in Excel 2002 and in Excel 2003 =

Article ID: 287117

Article Last Modified on 5/21/2007

-

APPLIES TO


 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition

-



This article was previously published under Q287117





SYMPTOMS
When you attempt to copy a worksheet that contains a PivotTable to another workbook, the copy operation fails, and no error message is displayed.



CAUSE
The sheet that you are trying to copy contains a PivotTable based on an OLAP cube. The OLAP cube contains member properties and the member property fields are displayed in the PivotTable.



WORKAROUND
Copy your PivotTable and paste it into a new workbook using the commands on the Edit menu. To copy the contents of the sheet with the PivotTable to another workbook, follow these steps:
 * 1) Select the range of cells that contains the PivotTable and any other data that you want to move to another workbook.
 * 2) On the Edit menu, click Copy.
 * 3) Open the workbook into which you want to paste the contents of the worksheet.
 * 4) On a blank worksheet, click the cell that you want as the upper left corner of the range of data, and then click Paste on the Edit menu.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

Additional query words: XL2002 XL2003

Keywords: kbbug kbpending KB287117

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.