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.

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.

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.

"T. Valko" wrote:

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.

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

On Wed, 30 Sep 2009 07:14:01 -0700, Gingerly
wrote:

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.

"T. Valko" wrote:

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.