Microsoft KB Archive/200187

= ACC2000: PivotTable Loses Connection to Data After You Demote Section =

Article ID: 200187

Article Last Modified on 6/24/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q200187



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
The Office PivotTable becomes disconnected from its data source immediately after you demote a section of a data access page that includes the PivotTable control.



RESOLUTION
Switch the data access page to Page view to rebind the PivotTable to its data source.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



MORE INFORMATION
If you have designed a data access page with a grouped section, and the section includes a PivotTable control, the PivotTable control will immediately lose its connection to its data source if you choose to demote the section.

Steps to Reproduce the Behavior
 Open the sample database Northwind.mdb or the sample Access project NorthwindCS.adp. In the Database windows, click Pages under Objects, and then click New. Click Design View, select the Orders table from the drop-down list, and then click OK. If the field list is not displayed, click Field List on the View menu. Drag OrderID field from the Orders table from the field list into the Section: Unbound section of the data access page. Drag the CustomerID field from the same table into the Header: Orders section of the data access page.</li> With focus still on the CustomerID text box, click the Promote button on the toolbar.</li> Click the Header: Orders-CustomerID bar and on the Insert menu, click Office PivotTable.</li>  With focus still on the PivotTable control, click Properties on the View menu. In the property sheet, click the Format tab, and then set the following two properties of the PivotTable control: <pre class="fixed_text">  Height: 3in Left: 3in </li> If the diagonal hash marks do not appear around the PivotTable control, click the control until the hash marks appear.</li> Right-click the PivotTable control, and then click Property Toolbox.</li> Expand Data Source, and select Orders from the Data Member list.</li> Close the PivotTable Property Toolbox, and then drag the following fields from the Orders table onto the respective sections of the PivotTable:

</li> Note that the PivotTable is properly bound without you having to switch to Page view. Right-click the CustomerID text box or the PivotTable control, and then click Demote. Note that the PivotTable control immediately displays: Unable to connect to data.</li></ol>

Additional query words: pra pivot table

Keywords: kbbug kbdap kbpending KB200187

-

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

© Microsoft Corporation. All rights reserved.