I created a pivot table that somehow interpreted one of my data points in two
different ways. In the table the value is shown as a left justified value and
a right justified value even though the source data is all General, Left
(Indent). So there are two of the same value in the drop down box for
selection in the table and I have to select both in order to include all data
points with this single value. I have completely recreated the table and I
have made sure that the source data format is the same for all occurences of
the data field and then refresh the table. Still shows the two versions of
the single value. This is driving me crazy because I cannot fathom why Excel
does this.

Thanks

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200606/1