Link error

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?
 
C

Conan Kelly

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
 
K

Ken Leach

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
Linking workbooks; experiencing random "#n/a" error 0
How to create absolue path link to another workbook (Excel 2003) 1
Multiple Files Sharing Common Link Revert to Most Recently Saved 0
Visio shape text disappears upon copy paste 1
Linking data in MS Word into Excel 5
Links error when insert line/row to source workbook 1
Trying to create a dynamic filepath within VB 3

Top