Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 200 Pivot Field Selections Are Locked
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 200 Pivot Field Selections Are Locked
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 200 Pivot Field Selections Are Locked
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 200 Pivot Field Selections Are Locked
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 200 Pivot Field Selections Are Locked
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 200 Pivot Field Selections Are Locked
Just one of those Excel mysteries we encounter. Glad it's working now.
David From Momentive wrote: 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 -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot data field settings seemed to be locked? | Excel Discussion (Misc queries) | |||
Multiple Pivot Chart Series Lists - Limit selections | Excel Discussion (Misc queries) | |||
Question regarding pivot table selections | Excel Discussion (Misc queries) | |||
Pivot Tables - How can I "reset" the selections in "Row Field"? | Excel Discussion (Misc queries) | |||
How do I get "multiple selections" displayed in Pivot Table Field | Setting up and Configuration of Excel |