pivot table - keep field list displayed

[bigdan]

Hello

Simple question here but I cant find it on google.

With pivot tables we can display the Field List. But mine keeps disappearing when my cursor isnt on the pivot table. Is there a way to always keep it displayed?

 

[Starnub]

From what I see, there doesn't seem to be a way. You could create a macro using the Application.OnKey method, and designate a key press to select a cell in your PivotTable.
I did an hour or so of searching but I could still be wrong, maybe use this as a temporary solution until you find a way?

 

[bigdan]

You did an hour of searching for me? Thanks a lot bud!!! Really appreciate the diligence. Cheers!
I'll go with your solution.