I use links to connect several sheets in a workbook. When I click on the
destination cell it shows the formula for the source cell, but when I change
the data in the source cell it does not update the destination cell. This is
not consistent and rather frustrating. Any suggestions?

Ken,

Is Calculatin set to automatic? In XL 2002/2003:

Tools Options... Calculation tab

Which option is selected (choices are Automatic, Automatic except tables, &
Manual)?

HTH,

Conan




"Ken Leach" wrote in message
...
I use links to connect several sheets in a workbook. When I click on the
destination cell it shows the formula for the source cell, but when I
change
the data in the source cell it does not update the destination cell. This
is
not consistent and rather frustrating. Any suggestions?

If XL 2007.......sorry can't help you out there, but something kinda
similar.







"Conan Kelly" wrote in message
...
Ken,

Is Calculatin set to automatic? In XL 2002/2003:

Tools Options... Calculation tab

Which option is selected (choices are Automatic, Automatic except tables,
& Manual)?

HTH,

Conan




"Ken Leach" wrote in message
...
I use links to connect several sheets in a workbook. When I click on the
destination cell it shows the formula for the source cell, but when I
change
the data in the source cell it does not update the destination cell. This
is
not consistent and rather frustrating. Any suggestions?

Yes it is set to Automatic. Should I change it?

"Conan Kelly" wrote:

Ken,

Is Calculatin set to automatic? In XL 2002/2003:

Tools Options... Calculation tab

Which option is selected (choices are Automatic, Automatic except tables, &
Manual)?

HTH,

Conan




"Ken Leach" wrote in message
...
I use links to connect several sheets in a workbook. When I click on the
destination cell it shows the formula for the source cell, but when I
change
the data in the source cell it does not update the destination cell. This
is
not consistent and rather frustrating. Any suggestions?