Knowledge Base

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

Article ID: 202841

Article Last Modified on 6/29/2004

APPLIES TO

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.

Additional query words: prb pivot table chart graph paste copy empty has nothing

Keywords: kbdap kbprb KB202841


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.