Calculate Help

[Steve]

Hi, I have a large spreadsheet and would like to calculate part of it
only.

A) Is this possible by simply selecting the columns and rows that I
want to calculate and;

b) is there a way to tell when the calculation has completed or do I
need to wait until it reaches 100% each time I run it?

There are a large number of cells and when the calculate progress gets
to 1% it looks like the calculation has completed although it can some
time before it reaches 100%

Thanks in advance

Steve

 

[joeu2004]

Hi, I have a large spreadsheet and would like to
calculate part of it only.
A) Is this possible by simply selecting the columns
and rows that I want to calculate

Sort of, if you are willing to put them into a separate worksheet.

I use the following technique especially for randomly-generated data. It
ensures that recalculations are done only when I want them.

Put the following macro into the VBA worksheet module by right-clicking on
the worksheet tab in Excel and clicking on View Code:

Sub doCalc()
EnableCalculation = False
EnableCalculation = True
EnableCalculation = False
End Sub

Execute the macro at least once so ensure that the state of
EnableCalculation is False.

Now the worksheet will be recalculated only when you execute the macro.

FYI, the first EnableCalculation=False is primarily needed only for the
first time. But it is "good programming practice" (defensive programming)
just in case EnableCalculation is True for some inexplicable reason.

The key is: recalculation is done only when EnableCalculation transitions
from False to True. Simply setting EnableCalculation to True does not cause
recalculation if it is already True.

PS: I like to set up a "button" (control) and assign the macro to it so
that it is easy to re-execute the macro at will.

 

[Steve]

Hi and thanks for the prompt reply.

Unforutunately I cannot put the fields into a sperate worksheet as it
is not just on calculation I need to do but sperate ones which are all
based on other cells in the master spreadsheet.

Is there any way that I can get the PC to let me know when the
calculation has finished...Someone mentioned pressing a function key
(F11) on the keybaord and you would know if the calc had finished when
the fucntion was carried out ?

Thanks anyway for a detailed and helpful reply

Steve

F11 and when the calc finished On Wed, 23 May 2012 11:02:53 -0700,