Every time I start up Excel For Mac 2011 and build a Pivot Table, Excel feels it's needed to remind me in a modal what Pivot Tables do ("PivotTables summarize data and reveal patterns and trends").

Is there a way to disable that modal completely?

enter image description here

  • I never noticed that. MS has secretly began to turn the pivot table builder into Clippy! – Raystafarian Jun 23 '15 at 9:26

Artist's Rendering -

enter image description here

The only way I got it to disappear was by going to-

Excel - preferences - view and on the right side unchecking show function ScreenTips

Then after I restarted, I went back and re-enabled those screentips (because come on, function screentips are needed!) and it didn't show up when I created another pivot table.

enter image description here


Display or hide a contextual ScreenTip

A contextual ScreenTip is summary information about the value, row, or column for a field. For example, if you move the pointer over a cell in the values area, a contextual ScreenTip displays the current value and the row and column location. This contextual ScreenTip is especially useful when you are working with a large report and do not want to change the layout or scroll through the report to find or verify this information.

Click the PivotTable report.

On the Options tab, in the PivotTable group, click Options.

In PivotTable Options dialog box, click the Display tab and then, under Display, select the Show contextual tooltips check box.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.