Refreshing formulas automatically

  • Thread starter Thread starter Gingerly
  • Start date Start date
G

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.
 
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.
 
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
 
Back
Top