Hi. My first post. I use office 365 and have attempted to fix the following issue using previous versions of excel as well. I have also tried other computers and also copying the tab to another workbook. Anyway here is the issue.

My spreadsheet has 4 tabs. The first is the actual pivot table. The other tabs are pivot reports. I only have an issue with the pivot table tab. The others work fine. When I click on the pivot table or try to enter data it will take a few seconds to accept the data and will sometimes freeze all together. You can actually see the cells refreshing (in no particular order) even if you just move from one cell to another. I have checked the formulas for consistency, removed any formatting and even removed some columns and set it to manually calculate. Still have the same issue. It runs really slow and just keeps refreshing

The spreadsheet is under a meg in size and the pivot table only has about 600 rows and 20 columns. Any advice would be appreciated.