Re-Calc

[Jerry]

Is it possible to setup Excel to do a manual re-calc on only one ( or only
specific ) worksheet(s)?

I have a spreadsheet where one worksheet is a huge RNG. Another sheet holds
converted data based on the random data and a third sheet takes real data
which is input on a regular basis.

The object of the program is to do what-ifs based on the differences between
the random and real data.

The problem is that the random data does not _HAVE_ to be re-genned
everytime and the real data takes about 1 minute to enter, but then, to
carry out the exercise, I have to wait an eternity whilst the RNG sheet
re-calcs.


TIA

PITA

 

[Niek Otten]

SHIFT+F9 calculates only the active worksheet

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Flamikey]

Tools/Options/Calculate/Caluculate Sheet or Shift+F

 

[Ken Wright]

If you are running a macro to get your sample data you can always turn off the
calculation status for individual sheets whilst you collect it. Even if you are
entering data manually, you can still have a routine that toggles calculation
status for the other sheets, eg, assign the following to a button on the Data
Entry sheet and put in all the sheets you want to toggle:-

Sub ToggleCalc()

Dim m As String
Dim sht1 As Worksheet
Dim sht2 As Worksheet
Dim sht3 As Worksheet

Set sht1 = Sheets("Sheet abc")
Set sht2 = Sheets("Sheet def")
Set sht3 = Sheets("Sheet ghi")

sht2.EnableCalculation = Not sht1.EnableCalculation
sht3.EnableCalculation = Not sht1.EnableCalculation
sht1.EnableCalculation = Not sht1.EnableCalculation

If sht1.EnableCalculation = True Then
m = "ON"
Else: m = "OFF"
End If

MsgBox "You have turned Calculation Status <" & m & "> for the following
sheets:-" _
& vbCrLf & vbCrLf & sht1.Name & vbCrLf & sht2.Name & vbCrLf & sht3.Name

End Sub

This will also give you a message as to which sheets you have toggled and what
their status is.

 

[Mike A]

Here are two more suggestions:

If you want the same random numbers every time, select all of the
random values, copy, and click Edit>Paste Special... then select
'Values' and paste over the same cells. This will replace the
formulas with the displayed values, and there will be nothing to
calculate.

Or, you can open the Visual Basic window (Alt-F11) and select the
sheet with the random values in the project window. This gives you
access to advanced sheet properties in the properties window. Change
EnableCalculation to False, and close the Visual Basic window. If you
want to generate new random data later, go back in there and re-enable
it.

Is it possible to setup Excel to do a manual re-calc on only one ( or only
specific ) worksheet(s)?

Mike Argy
Custom Office Solutions
and Windows/UNIX applications

Please post on-topic responses to the newsgroup

To e-mail me, remove nospam from the address in the headers