<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?
|