How can I check/verify data in my Data Source for Pivot table?
 

When I sort my data source on a different column (example column A) I get
one result, and if I go sort on another column (example column F) and refresh
data I get different results- when I havent changed any data - only the
sorting. I found one other time I had mixed data in a column (most entries
dated March or April, but one had 4/2009). I have been checking for similar
problem....but have not found any obvious errors.
Question is - is there an easy way I can do some sort of Check on my
data?????? to pinpoint issues? Thanks!

How can I check/verify data in my Data Source for Pivot table?
 

I think this will do it for you:
http://www.contextures.com/xlPivotPlayPLUS01.html

Regards,
Ryan---

--
RyGuy


"gayleh" wrote:

When I sort my data source on a different column (example column A) I get
one result, and if I go sort on another column (example column F) and refresh
data I get different results- when I havent changed any data - only the
sorting. I found one other time I had mixed data in a column (most entries
dated March or April, but one had 4/2009). I have been checking for similar
problem....but have not found any obvious errors.
Question is - is there an easy way I can do some sort of Check on my
data?????? to pinpoint issues? Thanks!