ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   ticked items on Pivot tables (https://www.excelbanter.com/excel-discussion-misc-queries/113856-ticked-items-pivot-tables.html)

Matt123

ticked items on Pivot tables
 
When i create a pivot tables I should be able to remover data items by
clicking on the ticks and turning them off. But i can't do it. However if i
email the worksheet to a colleague they can turn off the ticks. What setting
must i change on my Excel?

Help! this is driving me crazy.

Debra Dalgleish

ticked items on Pivot tables
 
What version of Excel are you using? Is your colleague using the same
version?

Matt123 wrote:
When i create a pivot tables I should be able to remover data items by
clicking on the ticks and turning them off. But i can't do it. However if i
email the worksheet to a colleague they can turn off the ticks. What setting
must i change on my Excel?

Help! this is driving me crazy.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 03:58 PM.

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