Spreadsheet calculates too slowly

[wflabqueen]

I have a mid-sized workbook ~14MB that takes far too long to calculate. One sheet contains all a data table with ~32,000 lines and 44 columns. 16 columns have formula and the rest are just text or number, four of which use INDIRECT which I know is a volatile function. One sheet contains all my pivot tables (which are not all built yet) and one sheet is the dashboard (not completed either). I have turned off automatic calculation and set the calculation to use all processors to speed things up which has helped. But I am afraid that when all the pivot tables are built this will calculate even slower. I have VBA code that copies data from another source to populate the data table and shows as linked data in Info.

What I would like to happen is:

A) Add VBA code to recalculate the formulas in the data table and refresh the pivot tables once certain cells are selected and changed.

B) figure out any other way to speed this workbook up.

I have read many posts here to get answers to other questions and can do some VBA code but this is my first post. Any help is welcome.

 

[wflabqueen]

I see what you are doing.... but this doesn't seem to work. It gives me the value for that particular month in that row and not the sum from that month forwards. But I like the concept.