Thread: How can I check/verify data in my Data Source for Pivot table?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ryguy7272 ryguy7272 is offline
external usenet poster
  
Posts: 2,836
Default 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!
Reply With QuoteReply With Quote