Excel 2010 Pivot table field list

M

MattWieneke

New Member
Joined
Aug 19, 2010
Messages
5
Good Morning Mr. Excel message board,

I am having a very difficult time creating a pivot table in excel 2010 to track some of my expenses. The problem is that the field lists are not showing up like they used to in 2007. I have clicked show field list, but no matter what I try they will not show up. If somebody knows a quick fix to this situation please let me know. This would be very appreciated. Nothing I have searched with troubleshooting has led me in the right direction. Thanks.

Have a wonderful day,

Matt
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
Sort by date Sort by votes
Most likely, you have a corrupt Excelxx.xlb where xx is the version of Excel: 12 for 2007, 14 for 2010 and is located in your Windows user profile which varies with OS (Documents and Settings or Users).
C:\Documents and Settings\Username\Application Data\Microsoft\Excel
C:\Users\UserName\AppData\Roaming\Microsoft\Excel.
Delete the file. Excel will recreate it the next time Excel is opened. You will lose any custom settings you may have made for Excel.
 
Upvote 0
I am so greatfull for this solution - 1) No field list showing was driving me mad for two days ! 2) have a job interview tomorrow and have a book of Advanced Reports which includes Pivot tables which I need to expand my knowledge of at home for a comfortable and confident job interview - thank you
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Question Question
Using SUMIF(?) in a Pivot Table to only show amounts for certain fields
Replies
1
Views
211
alansidman
alansidman
kristell
  • Solved
Pivot table date format
2
Replies
10
Views
158
RoryA
RoryA
S
  • Question Question
How do I create a pivot table with a simple timesheet table?
Replies
0
Views
40
studioacosta
S
J
  • Question Question
Difficulties in Refreshing Pivot Tables in Excel 2024 When the Source Table and/or Pivot Tables have Protected Cells
Replies
0
Views
46
jfrsanders
J
J
  • Question Question
Employee Timesheet Pivot Table
Replies
2
Views
267
alansidman
alansidman

Forum statistics

Threads
1,226,167
Messages
6,189,367
Members
453,540
Latest member
PPRx

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top