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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking workbooks together 1
Link error #VALUE 5
edit link source 1
#N/A in linked cell 4
Links error when insert line/row to source workbook 1
Updating Links from Closed Source Workbooks 2
How to create absolue path link to another workbook (Excel 2003) 1
Need help with a function 1

Back
Top