I have to believe someone else has had this problem. I just began a new job (previously created/updated 54 pivot reports monthly on Excel 2010 with no issues, ever) that is using Office 2013. Excel doesn't appear to process filtered columns correctly. I have created a matrix in a bar chart, and every time I try to update the data, it counts everything instead of just the filtered items selected and ruins the whole chart. I'm getting very frustrated. I haven't been able to find a known issue, although there may be one out there somewhere. Can you help, please?