Link error
 

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?

Link error
 

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?

Link error
 

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?

Link error
 

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?