Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Since SP2, my pivot tables cannot select various fields
Prior to the installation of SP2 on my computer, I was able to click on one
field in the pivot table and the 'similar' fields would be highlighted (an easy way to hide unnecessary information). Now this does not work since the SP2 installation. Any suggestions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Since SP2, my pivot tables cannot select various fields
Maybe Enable Selection was turned off.
To enable selection -- From the Pivot toolbar, choose PivotTableSelect If it's not already activated, click on Enable Selection tlld wrote: Prior to the installation of SP2 on my computer, I was able to click on one field in the pivot table and the 'similar' fields would be highlighted (an easy way to hide unnecessary information). Now this does not work since the SP2 installation. Any suggestions? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Since SP2, my pivot tables cannot select various fields
Thank you...that's exactly what it was!
"Debra Dalgleish" wrote: Maybe Enable Selection was turned off. To enable selection -- From the Pivot toolbar, choose PivotTableSelect If it's not already activated, click on Enable Selection tlld wrote: Prior to the installation of SP2 on my computer, I was able to click on one field in the pivot table and the 'similar' fields would be highlighted (an easy way to hide unnecessary information). Now this does not work since the SP2 installation. Any suggestions? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Since SP2, my pivot tables cannot select various fields
You're welcome! Thanks for letting me know that it fixed the problem.
tlld wrote: Thank you...that's exactly what it was! "Debra Dalgleish" wrote: Maybe Enable Selection was turned off. To enable selection -- From the Pivot toolbar, choose PivotTableSelect If it's not already activated, click on Enable Selection tlld wrote: Prior to the installation of SP2 on my computer, I was able to click on one field in the pivot table and the 'similar' fields would be highlighted (an easy way to hide unnecessary information). Now this does not work since the SP2 installation. Any suggestions? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot tables - calculated fields and items | Excel Discussion (Misc queries) | |||
Calculated fields in pivot tables | Excel Worksheet Functions | |||
Calcualted Fields in Pivot Tables | Excel Worksheet Functions | |||
Not including blank fields in pivot tables | Excel Worksheet Functions | |||
Pivot Tables - Variance and % Variance fields | Excel Discussion (Misc queries) |