Article ID: 2012844 - View products that this article applies to.
When you create a Pivot Chart or a Pivot Table in Microsoft Office Access 2007, the Field List does not appear.
When the Current Database Document Window option in Microsoft Office Access Options is set to the default, "Tabbed Documents," the Field List is hidden behind the form even though the Ribbon Field List icon indicates it is not hidden.
Microsoft has confirmed this is a problem in Microsoft Office Access 2007.
On the Ribbon Design tab in the Show/Hide group, click twice on the Field List icon.
The Field List will be visible in new Pivot Charts and Pivot Tables when the Current Database option for Document Window Options is "Overlapping Windows."
Steps to reproduce
(http://go.microsoft.com/fwlink/?LinkId=151500)for other considerations.
Article ID: 2012844 - Last Review: May 25, 2010 - Revision: 1.0