Excel 200 Pivot Field Selections Are Locked

  • Thread starter David From Momentive
  • 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
 
D

Debra Dalgleish

What version of Excel are you using?
In which version of Excel was the pivot table created?
Is the worksheet protected?
 
D

David From Momentive

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?
 
D

Debra Dalgleish

Can you create a pivot table from different data in other workbooks?
Is it just this data that is the problem?
 
D

David From Momentive

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

Change a pivot table field by typing into another cell 2
How Do I Change Two Pivot Table Page Selections with VBA Code 1
Pivot Table Field Reordering 4
excel advanced question 3
Pivot Table Change to US Date Format - Why? 2
Pivot report and Filter boxes 1
prevent pivot tables / charts from editing 1
linking pivot table selections 2

Top