PivotTable - The strangest thing i've ever seen in Excel!

P

pluginbabies

New Member
Joined
Jul 14, 2009
Messages
1
Ok, let me explain my problem, i'm completely stumped!

I have a spreadsheet with a column containing the following values (names changed for confidentiality!)

OrangeGreen
GreenRed
BlueRed

I have a pivottable based on this data, with the field containing these values in the page area (i've tried it in the row area and the same happens). When i open the filter dropdown box i get the following options

BluuRed (this was previously in the original data as a misspelling, but now corrected)
BlueRed
BlueRed2
GreenRed

and OrangeGreen is missing...very strange! :confused:

If i then do a 'show details' to see what the underlying data is, the values are correct per the original data, but don't tie through to the values shown in the pivottable, however they map as follows

BluuRed >>> GreenRed
BlueRed >>> no data
BlueRed2 >>> BlueRed
GreenRed >>> OrangeGreen

Anyone seen this before????

I have refreshed the data numerous times!!
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
Sort by date Sort by votes
Hi, welcome.

Pivot tables do keep a list of previous values that used to be in the table, even if they are no longer actually in the data. I suspect you are seeing this "missing items" list in the dropdown.

Try the following:

1) Take all fields out of the pivot table (basically until its a bare "pivot skeleton").
2) Refresh the empty pivot table
3) Now put the fields/data back in.

You should see the drop down only containing actual current values now.

Does that help?
Alex
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question
Too many characters in the cells of my Pivot Table?
Replies
0
Views
418
SorenN
S
D
  • Question
Excel on Mac - file repair issues
Replies
1
Views
1K
dskills
D
T
  • Question
vba Combined line and area chart in vba
Replies
2
Views
342
travellerva
T
N
  • Question
2-step Dynamic Ranges and Charts
Replies
0
Views
134
Nick Loughton
N
A
  • Question
Two dimensional dynamic named range over a pivot table not working as I thought
Replies
4
Views
261
ashleighbrown
A

Forum statistics

Threads
1,214,622
Messages
6,120,572
Members
448,972
Latest member
Shantanu2024

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