Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to search for and display data in another worksheet | Excel Worksheet Functions | |||
How do I open to a specific worksheet every time? | New Users to Excel | |||
Automatically Populating Worksheet from Collected Input for Pricelist | Excel Worksheet Functions | |||
Automatically Populating Worksheet from Collected Input for Pricelist | Excel Worksheet Functions | |||
print a specific area within a worksheet by clicking on print? | Excel Worksheet Functions |