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?