ACC2000: Data from Chart or PivotTable Is Not Copied When You Copy Chart or PivotTable from One Data Access Page to Another (202841)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q202841

Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

SYMPTOMS

You can copy and paste Office Charts and Office PivotTables from one data access page to another. However, the data in the Chart or the PivotTable is not copied from one page to the other.

CAUSE

The process does not copy the schema information. Therefore, the data does not appear in the destination data access page.

RESOLUTION

Instead of copying and pasting the Chart or the PivotTable, create a new Chart or PivotTable on the destination page.

MORE INFORMATION

Steps to Reproduce the Behavior

  1. Open the sample database Northwind.mdb.
  2. In the Database window, click Pages.
  3. Click the Sales page, and then click Design.
  4. Click the Chart1 chart. Note that the chart contains data.
  5. On the Edit menu, click Copy.
  6. Press F11 to switch to the Database window, and then click New.
  7. In the New Data Access Page dialog box, click Design View, and then click OK.
  8. On the Edit menu, click Paste. Note that the chart does not contain any data.
Modification Type:MajorLast Reviewed:6/29/2004
Keywords:kbDAP kbprb KB202841
©2004 Microsoft Corporation. All rights reserved.