Only calculate specific worksheet automatically?
 

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


--
qflyer
------------------------------------------------------------------------
qflyer's Profile: http://www.excelforum.com/member.php...o&userid=24448
View this thread: http://www.excelforum.com/showthread...hreadid=382387

Shift-F9 will calculate an individual worksheet.
If you set your workbook to 'Manual', that should help. I know it's not
exactly what you want but your workbook is either in 'Automatic' mode or
'Manual' mode.
HTH,
--
Gary Brown

If this post was helpful, please click the ''''''''Yes'''''''' button next
to ''''''''''''''''Was this Post Helpfull to you?".


"qflyer" wrote:


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


--
qflyer
------------------------------------------------------------------------
qflyer's Profile: http://www.excelforum.com/member.php...o&userid=24448
View this thread: http://www.excelforum.com/showthread...hreadid=382387