A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Hello Katrinah,
Since the issue is related to Pivot table, you may also to post this query in the following TechNet forum for better suggestions.
http://social.technet.microsoft.com/Forums/en/excel/threads
If you have any other queries related to Office products, feel free to reply and I'll be happy to further assist you.
Thank you.