Excel 200 Pivot Field Selections Are Locked

  • Thread starter Thread starter David From Momentive
  • Start date Start date
D

David From Momentive

I have opened a worksheet with a pivot table in it. When I try to change (by
clicking in the selection box) in the dropdown field to show only the
selections I want to see I cannot, the boxes are locked. How do I enable the
ability to change these selections
 
What version of Excel are you using?
In which version of Excel was the pivot table created?
Is the worksheet protected?
 
Debra,
Iam am using Excel 2000 and the worksheet is not protected. I copied and
pasted the data form the excel spreadsheet I had issues with into another
spreadsheet and had the same issue. Any ideas?
 
Can you create a pivot table from different data in other workbooks?
Is it just this data that is the problem?
 
I repasted the data and the pivot dropdown worked - can't explain why.
Thanks for you help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to partially protect a pivot table based worksheet 8
Pivot table filter list - listing irrelevant subcategorys 1
Excel 2007 pivot table source table 1
Excel Pivot Tables 1
Pivot table grand total location 1
Pivot Table criteria 2
Count of Non-Zero pivot table entries 1
Pivot table change data source 1

Back
Top