• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot table field list

A

Anush

New Member
we have a very complicated field list in pivot table with lot of hierarchies. We want to build a context sensitive help (hover over text) for the field list - explaining all of the fields within the pivot table field list. Has anyone come accross such issue? how can you resolve it. Any tips and advice would help. Really appreciate your time.

Thanks in advance,
Anush
 
This can be done, but would require VBA. Another alternative is to just use the Input Messages functionality of Excel's Data Validation feature, whereby a tooltip is displayed when a cell is clicked.
http://www.contextures.com/xlDataVal04.html

Note that if users will be altering the structure of the PivotTable, then you would need some VBA to move the data validation input boxes around.

I'm afraid I don't have time to help out with any VBA for you.
 
You must log in or register to reply here.
Back
Top