Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You can use programming to disable selection. There's sample code he
http://www.contextures.com/xlPivot12.html sreenath205 wrote: Hi All If i add a field to pivot tables ROW area it appears as a drop down.How to remove that drop down?ie all options should be shown no option for filtering should be given. Thanks in Advance Sreenath -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
keyboard shortcut doesn't work on data area of pivot table | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
How to get pivot table Time field to appear correctly | Excel Worksheet Functions | |||
pie-charting non-numeric data | Charts and Charting in Excel |