View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
gayleh gayleh is offline
external usenet poster
 
Posts: 1
Default 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!