ExcelBanter - Pivot table Calculations

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pivot table Calculations (https://www.excelbanter.com/excel-discussion-misc-queries/118449-pivot-table-calculations.html)

pivot table drop down values

Pivot table Calculations

I added a formula to my rather large pivot table however when I refreshed it
it calculates & after a few minutes it eventually Excel closes.

I think the file is too large. Approx 8000 rows 20 columns

All times are GMT +1. The time now is 04:20 AM.