Refreshing formulas automatically
 

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.

Refreshing formulas automatically
 

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.

Refreshing formulas automatically
 

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.

Refreshing formulas automatically
 

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.