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.