If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can I calculate a single page ONLY?
Can I calculate a single sheet only, and disable calculation update on other
sheets? I have several sheets that take a few seconds (too long, in my case) to re-calculate where I'm running a macro that plugs a value into a cell and gets an answer, plugs another value in and gets an answer, etc. I'd like to calculate only the sheet where where the calculations are actually being affected-I'm not concerned with the other sheets. Thanks DH |
#2
|
|||
|
|||
Can I calculate a single page ONLY?
Excel 2003 & 2007 (at least!) have the option to calculate only the current
sheet. Calculation must be set to Manual first. In XL2007 select Formulas ribbon Calculation section Calculate sheet. In XL2003 select Tools Options Calculation tab Calc Sheet. In either version the VBA command is: ActiveSheet.Calculate Hope this helps, Hutch "dh13134" wrote: Can I calculate a single sheet only, and disable calculation update on other sheets? I have several sheets that take a few seconds (too long, in my case) to re-calculate where I'm running a macro that plugs a value into a cell and gets an answer, plugs another value in and gets an answer, etc. I'd like to calculate only the sheet where where the calculations are actually being affected-I'm not concerned with the other sheets. Thanks DH |
Thread Tools | |
Display Modes | |
|
|