|
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 |
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 |
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 09:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com