Calculate only a specified range?

[llcooljabe]

Is there a way to calculate a specified range without calculating the entire spreadsheet. Currently I highlight the range and search and replace the equal signs with equal signs. Is there a more efficient way?

 

[Brian from Maui]

Yes, but give an example

 

[llcooljabe]

For example: I have a huge multi page spread sheet. If I change a series of values to see what happens, how do I, say, confine the recalculation to the sheet that I'm on. Or even more finely, a specified range, let's say A1: Z500.

 

[Qroozn]

Tools/options/calculation/[calculate sheet]
will calculate just one sheet at one time.
or [Shift] & [f9]
This message was edited by Qroozn on 2002-06-17 16:46

 

[Joe Was]

You may want to look into the Excel Scenario method. This built-in utility in Excel will allow you to select certain cells on a sheet that you assign different values to in a what-if style. Think of it as a roller-dex of sheets all alike, except for some cells.

If you had a sheet set up to calculate a loan you could set up a scenario which flips sheets for a 6%, 6 1/2%, 7% and 7 1/2% loans. This may help. JSW

 

[Qroozn]

'you could use the VBA code
'To calculate your specified range.

sub calcnow()
range ("a1:z500").calculate
end sub
This message was edited by Qroozn on 2002-06-17 16:59

 

[llcooljabe]

Thanks all. I've taken Qroozn's suggested code and put it in my personal.xls:

sub calcnow()
Selection.calulate
end sub

Very much appreciated.

 

[Mark W.]

On 2002-06-14 12:31, llcooljabe wrote:
Is there a way to calculate a specified range without calculating the entire spreadsheet. Currently I highlight the range and search and replace the equal signs with equal signs. Is there a more efficient way?

When calculation is set to Automatic the entire spreadsheet isn't necessarily recalculated -- only those cells whose contents have been edited or updated, that contain a volatile function, and that are dependent on another cell whose contents have changed will be recalculated. See the Excel Help topic for "About calculation in workbooks".

I hope that you're not suggesting that you can set your calculation mode to Manual, selectively recalculate a specific cell range, and expect the worksheet to produce correct results!

If you're trying to address sluggish recalculation consider the tips for improving performance at http://support.microsoft.com/default.aspx?scid=kb;EN-US;q72622.
This message was edited by Mark W. on 2002-06-18 15:33