Make sure calculation is set to automatic.

ToolsOptionsCalculation tabAutomaticOK

--
Biff
Microsoft Excel MVP


"Gingerly" wrote in message
...
I am working in Excel 2003. I have a spreadsheet that I'll call Priority 1
that contains data. I created another spreadsheet I'll call Formulas
whose
purpose is to pull the data from the Priority 1 spreadsheet. Here is how
I
do it. I open Priority 1 and create a new worksheet in this spreadsheet.
I
then copy Formulas into this new worksheet. The only way the formulas
refresh is for me to go into each cell and press F2 (as if I am going to
edit
the cell) then press RETURN. Is there a way that the Formulas worksheet
can
calculate automatically as soon as it is pulled into the Priority 1
spreadsheet? One thing I have noticed is that my REFRESH menu choice is
grayed out. Thanks in advance for any help.