• 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.

Pivottable field list disappeared

N

neeraj2050

Member
Greetings!!
Pivot table field list is not being appeared. I tried Pivot table options, right clicked and click show field list. Nothing is working. And it happens with all the files.
Regards
Neeraj Kumar Agarwal
 
Hi,

First! This might happen due to any conflicts in user vs Office files. Try with another user , if not then create a new user & try.

Another would be..
Try this in a immediate window [Press Alt+F11 > Ctrl+G>Pate below code>Hit Enter>Now Check]

Code: 
ActiveWorkbook.ShowPivotTableFieldList = true

You may also troubleshoot it by visiting here..

https://support.microsoft.com/en-gb/kb/919196
 
Thanks!! But that didn't help.

With other pc's file works but in my laptop it is not being worked. I tried your suggestion and mentioned the same into Immediate Window but that is also not working.
 
neeraj2050 said:
Thanks!! But that didn't help.

With other pc's file works but in my laptop it is not being worked. I tried your suggestion and mentioned the same into Immediate Window but that is also not working.
Click to expand...

Have you checked with another user on your laptop. Also try to repair the office setup & check..
 
I'd also suggest closing the PC and restarting it

Can it have been moved off the screen and hence doesn't appear visible ?
 
On a copy of the file, try deleting the PT
Close and Save the file
Re-open it
Then remake the PT
 
You must log in or register to reply here.
Back
Top