A
Aaron
I have a workbook that contains 1,000 rows. The workbook has months
accross (from Jan-01 to present). There are 'Sumif' formulas in every
cell for every month. When the workbook was first created it would
save on demand. However, the file now takes approximately 2 - 3
minutes to save. I suspect the numerous 'Sumif' formulas carry a lot
of overhead. What can I do to get it to save faster.
Note: The Sumif formulas are linking to data in another workbook
accross (from Jan-01 to present). There are 'Sumif' formulas in every
cell for every month. When the workbook was first created it would
save on demand. However, the file now takes approximately 2 - 3
minutes to save. I suspect the numerous 'Sumif' formulas carry a lot
of overhead. What can I do to get it to save faster.
Note: The Sumif formulas are linking to data in another workbook