I Created a pivot table on excel 2007 and the results match the original data. When the same file is opened from a mac, the pivot table shows different figures. When I check the original data on the mac, it is the same data but the pivot table is showing different results. Can not figure what is causing this and can not find any relevant searches that match this so any advice is appreciated. I suppose the file in excel can be copied and pasted as values and sent.