Jump to content


Photo

Missing Field List - Pivot Table

pivot tables field list

  • Please log in to reply
4 replies to this topic

#1 Elpatico

Elpatico

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 12 September 2014 - 10:06 AM

I have a Table of data and have created a pivot table from it, from which I used slicers to filter the pivot table. For some reason the Field list has now disappeared even though it is highlighted on the menu bar. I cannot create a new pivot table report as I can't arrange data into fields. I'm using Excel 2010. Please can anyone help?



#2 Jonathan

Jonathan

    Forums Administrator

  • Administrators
  • 887 posts

Posted 12 September 2014 - 06:34 PM

This article has moved

 

We have moved this article to our new site. You can now see the answer to this question here:

 

https://thesmartmeth...st-pivot-table/


Jonathan is part of the professional team who answer Excel-related questions posted on the ExcelCentral.com forums.
Jonathan also tests our courses prior to publication and has worked on all of our ten world bestselling Excel books for Excel 2007, Excel 2010, Excel 2013, Excel 2016 for Windows and Excel 2016 for Apple Mac. Jonathan has also worked on over 850 video lessons for or video courses covering Excel 2007, Excel 2010 and Excel 2013.
As well as extensive Excel knowledge, Jonathan has worked in the IT world for over thirteen years as a programmer, database designer and analyst for some of the world's largest companies.


#3 Elpatico

Elpatico

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 13 September 2014 - 09:02 AM

Thank you for your reply admin. Unfortunately I still can't see the field list. The field list Icon on the show menu is selected and I haven't used two monitors. I think Excel has been corrupted, and I'm not sure how to do a repair install. Could you please help me with this?



#4 Jonathan

Jonathan

    Forums Administrator

  • Administrators
  • 887 posts

Posted 13 September 2014 - 06:30 PM

This article has moved

 

We have moved this article to our new site. You can now see the answer to this question here:

 

https://thesmartmeth...st-pivot-table/


Jonathan is part of the professional team who answer Excel-related questions posted on the ExcelCentral.com forums.
Jonathan also tests our courses prior to publication and has worked on all of our ten world bestselling Excel books for Excel 2007, Excel 2010, Excel 2013, Excel 2016 for Windows and Excel 2016 for Apple Mac. Jonathan has also worked on over 850 video lessons for or video courses covering Excel 2007, Excel 2010 and Excel 2013.
As well as extensive Excel knowledge, Jonathan has worked in the IT world for over thirteen years as a programmer, database designer and analyst for some of the world's largest companies.


#5 Elpatico

Elpatico

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 15 September 2014 - 06:25 PM

Thank you for your reply admin. I tried the repair feature, but unfortunately that didn't work either. So I did a bit of searching on the internet and eventually found what the problem was. For some reason a couple of files had found their way into my XLSTART folder (no idea how!), which prevented the field list from appearing (no idea why!). I just removed the files from the folder and the field list appears.







0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users