Refreshing formulas automatically

[Gingerly]

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.

 

[T. Valko]

Make sure calculation is set to automatic.

Tools>Options>Calculation tab>Automatic>OK

 

[Gingerly]

HI Biff,

That had been turned on previously. The only thing I find odd is that the
REFRESH DATA option on the DATA menu is grayed out.

 

[Gord Dibben]

Refresh Data is only functional when you have a Query set up for external
data.

Doesn't sound like that is your case here.

Sounds more like a calculation issue.

Show us a few examples of copied formulas from where to where.


Gord Dibben MS Excel MVP