Too many formulas, how do i fix?
I have a workbook with three sheets, all of which have formulas that depend
on each other to create the result. The issue is that each sheet have
approximately 21,000 records and multiple formulas for each record, so when
fully populated, the spreadsheet does not respond quickly (or at all) when
doing a query. Is there any way to compress the data or speed up processing
of the formulas?
Thanks,
Erin
|