Q
qflyer
Hey guys,
I've just added a worksheet to a workbook. This new worksheet only
contains formulas that refer to other worksheets in the workbook. This
worksheet has over 120 formulas in various cells, and they are all array
functions or SUMPRODUCT...The addition of this worksheet has slowed down
the entire workbook because it's updating every formula anytime I change
a cell in the rest of the workbook. Is it possible to make only one
worksheet update only when I tell it to but the other worksheets in the
workbook constantly update? The problem worksheet is very useful, but
simply too slow if it updates after every change.
Thanks a lot,
Scott
I've just added a worksheet to a workbook. This new worksheet only
contains formulas that refer to other worksheets in the workbook. This
worksheet has over 120 formulas in various cells, and they are all array
functions or SUMPRODUCT...The addition of this worksheet has slowed down
the entire workbook because it's updating every formula anytime I change
a cell in the rest of the workbook. Is it possible to make only one
worksheet update only when I tell it to but the other worksheets in the
workbook constantly update? The problem worksheet is very useful, but
simply too slow if it updates after every change.
Thanks a lot,
Scott