ACTIVATE CELLS

[Guest]

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?

 

[Ragdyer]

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

 

[Guest]

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 Tool>Options>Calculations to make sure it is set
to automatic.