ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Since SP2, my pivot tables cannot select various fields (https://www.excelbanter.com/excel-discussion-misc-queries/117027-since-sp2-my-pivot-tables-cannot-select-various-fields.html)

tlld

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?

Debra Dalgleish

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


tlld

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



Debra Dalgleish

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



All times are GMT +1. The time now is 01:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com