ACTIVATE CELLS
 

I have large matrix with forumlas that i want to copy into 65 different excel
files.
The formulas pick up new data in the destination file and return new results.

However, I need to use the F2 key and ENTER on each cell before the formulas
recalculate. I have a 25X20 matrix and this process takes a long time.

Is there a way to automatically activate the entire spreadsheet or range of
cells?

<Tools <Options <Calculation tab,
And make sure that "Automatic" *is* checked.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"mdeanda" wrote in message
...
I have large matrix with forumlas that i want to copy into 65 different
excel
files.
The formulas pick up new data in the destination file and return new
results.

However, I need to use the F2 key and ENTER on each cell before the
formulas
recalculate. I have a 25X20 matrix and this process takes a long time.

Is there a way to automatically activate the entire spreadsheet or range
of
cells?

Right click the tab for the sheet and click view code, copy this in

Private Sub Worksheet_Activate()

Calculate

End Sub


Alternatively press Alt F9 to recalculate

You may also want to check ToolOptionsCalculations to make sure it is set
to automatic.

--

_______________________
Naz,
London


"mdeanda" wrote:

I have large matrix with forumlas that i want to copy into 65 different excel
files.
The formulas pick up new data in the destination file and return new results.

However, I need to use the F2 key and ENTER on each cell before the formulas
recalculate. I have a 25X20 matrix and this process takes a long time.

Is there a way to automatically activate the entire spreadsheet or range of
cells?