I repasted the data and the pivot dropdown worked - can't explain why.
Thanks for you help

"Debra Dalgleish" wrote:

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


David From Momentive wrote:
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?


"Debra Dalgleish" wrote:


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

David From Momentive wrote:

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


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com





--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com