You may not be able to see areas for adding data when you create a pivot table in Excel 2002 (870697)


The information in this article applies to:

  • Microsoft Excel 2002

SYMPTOMS

When you create a pivot table in Microsoft Excel 2002, you may not be able to see the following areas:
  • Drop Column Fields here
  • Drop Row Fields here
  • Drop Page Fields here

CAUSE

This problem may occur if you have not activated a Microsoft Office program that you installed separately after you install and activate Microsoft Office XP.

RESOLUTION

To resolve this problem, follow these steps:
  1. Verify that you have activated Microsoft Office XP.

    If you install any other Office programs separately, such as Microsoft Publisher after you install and activate Microsoft Office XP, you must also activate those programs.
  2. Install the latest service pack for Microsoft Office XP.
To resolve this problem, obtain the latest service pack for Microsoft Office XP. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

307841 OFFXP: How to obtain the latest Office XP service pack

For additional information about how to activate Microsoft Office programs, click the following article number to view the article in the Microsoft Knowledge Base:

293151 About Office activation and reduced functionality

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

REFERENCES

For additional information about how non-activation of products affects functionality, click the following article number to view the article in the Microsoft Knowledge Base:

325834 OFFXP: Web components are static after you install Publisher 2002

Modification Type:MinorLast Reviewed:7/27/2006
Keywords:kbtshoot kbprb KB870697 kbAudEndUser kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.