ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2007 Pivot Table curser pop-ups (https://www.excelbanter.com/excel-discussion-misc-queries/142213-excel-2007-pivot-table-curser-pop-ups.html)

Ian Grega

Excel 2007 Pivot Table curser pop-ups
 
When the curser is held over a cell in a pivot table in Excel 2007 a data
window pops up showing details of what is in the cell.

This did not happen in my previous version of Excel and I find it annoying
but I can't find where to turn it off. I hope that you can, does anyone know
how ?

Thanks
Grega

Debra Dalgleish

Excel 2007 Pivot Table curser pop-ups
 
Right-click on a cell in the pivot table, and choose PivotTable Options
On the Display tab, remove the check mark from 'Show contextual tooltips'
Click OK

Ian Grega wrote:
When the curser is held over a cell in a pivot table in Excel 2007 a data
window pops up showing details of what is in the cell.

This did not happen in my previous version of Excel and I find it annoying
but I can't find where to turn it off. I hope that you can, does anyone know
how ?



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


Ian Grega

Excel 2007 Pivot Table curser pop-ups
 
Debra, thanks for that.

Regards
Ian

"Debra Dalgleish" wrote:

Right-click on a cell in the pivot table, and choose PivotTable Options
On the Display tab, remove the check mark from 'Show contextual tooltips'
Click OK

Ian Grega wrote:
When the curser is held over a cell in a pivot table in Excel 2007 a data
window pops up showing details of what is in the cell.

This did not happen in my previous version of Excel and I find it annoying
but I can't find where to turn it off. I hope that you can, does anyone know
how ?



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




All times are GMT +1. The time now is 12:58 AM.

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