Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - Duplicate values drop-down when I refresh data
My summary data seems okay but the same text is showing up more than once in
the field drop-down. How do I stop this from happening? THanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - Duplicate values drop-down when I refresh data
Usually data inconsistency. There's probably extra white spaces somewhere
within supposedly matching text which are not apparent/readily visible (especially trailing white spaces). Use TRIM() to clean up the source col(s), then refresh the pivot. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Vicky" wrote: My summary data seems okay but the same text is showing up more than once in the field drop-down. How do I stop this from happening? THanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - Duplicate values drop-down when I refresh data
Thanks, not sure that's it because sometimes they duplicate and other times
they dont. I will check it. Any other thoughts? "Max" wrote: Usually data inconsistency. There's probably extra white spaces somewhere within supposedly matching text which are not apparent/readily visible (especially trailing white spaces). Use TRIM() to clean up the source col(s), then refresh the pivot. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Vicky" wrote: My summary data seems okay but the same text is showing up more than once in the field drop-down. How do I stop this from happening? THanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - Duplicate values drop-down when I refresh data
"Vicky" wrote:
Thanks, not sure that's it because sometimes they duplicate and other times they dont. I will check it. Let us know the results of your check Any other thoughts? One other possibility - some source numbers are text, some are real. Make a decision. Convert all to either real numbers or all to text numbers. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Refresh Data Pivot Table | Excel Discussion (Misc queries) | |||
Why does the data shift out my outline when I refresh the Pivot table? | Excel Worksheet Functions | |||
Duplicate values in Pivot table Page Field dropdown.. | Excel Worksheet Functions | |||
Pivot table Data refresh | Excel Worksheet Functions | |||
Pivot Table Data Refresh | Excel Discussion (Misc queries) |