inter workbook links do not update even when both are open ???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We have very large workbooks which have links to each other. Usually when
opening a linked workbook to one that is already opened, excel identifies
this and updates the links between the two and the paths in the cell formula
reduce down. This does not seem to be happening in excel 2003.
 
Is calculation set to automatic (tools|options|calculation tab)?

Are you sure you have both workbooks open in the same instance of excel?

Check under Window. Do you see both workbook names at the bottom of that
dropdown?

If the workbooks are open in different instances, then the updating of links
won't be automatic.
 
Yes calculation is set to automatic
Yes both workbooks are open in the same session
 
You must log in or register to reply here.

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
Links only work with both workbooks open... 2
Link error #VALUE 5
workbook links 1
Breaking links between workbooks in Excel 2000 1
Linking workbooks together 1
Strange Message when opening workbook 3
Saving through a network affecting ability to update automatically 1

Back
Top