Hi,

There are slight differences between the way my pivot table is being displayed on Excel 2010 (Windows) and Excel for Mac 2011. I want someone to confirm if this is expected when a pivot table made in Windows is opened in Mac.

I have grouped my pivot table dates by months and years. I have also manually entered the start & end dates. As a result, in the pivot table, 2 additional columns are displayed in addition to the columns for the 12 months. One column is titled <1/1/2015 & the other >1/1/2015. This is normal.

When this same pivot table file is opened in Mac, the columns <1/1/2015 & >1/1/2015 do not exist.

Is this because of the differences in the way Excel is designed for Windows/Mac or is it something else?

Thanks a lot for your ideas.

Warm Regards,
Himanshu