Calculate only a specified range?

llcooljabe

Board Regular
Joined
Jun 13, 2002
Messages
76
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?
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
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.
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
'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
 
Upvote 0
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.
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,223,992
Messages
6,175,822
Members
452,672
Latest member
missbanana

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top