cells linked to others in same workbook not updating

G

Guest

I have created a spreadsheet with cells linked to others in the same
workbook. However, when I change the origin cell, the linked cell does not
update unless I go back to the linked cell and activate it. Cannot
understand why?
 
D

Dave Peterson

Check to see if calculation is set for automatic:

Tools|options|calculation tab
 

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

How to create absolue path link to another workbook (Excel 2003) 1
link two spreadsheets and copy cell ref accross row 2
Sharing workbooks limitations - Merged Cells 12
Link cell to another workbook 5
Linking workbooks together 1
Linking problems in Excel 2007 2
Saving through a network affecting ability to update automatically 1
Paste Values in linked Cells Only 4

Top