Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Source Data | Excel Discussion (Misc queries) | |||
Pivot table data source | Excel Discussion (Misc queries) | |||
verify pivot table source | Excel Discussion (Misc queries) | |||
Pivot Table data source | Excel Worksheet Functions | |||
Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions |