Link error

  • Thread starter Thread starter Ken Leach
  • Start date Start date
K

Ken Leach

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
 
Yes it is set to Automatic. Should I change it?

Conan Kelly said:
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
Click to expand...
 
Back
Top