Links not updating automatically
Hi Lisa
Please help us with a bit more information:
- which version of Excel are you using?
- might the source workbook have been saved by an earlier version of
Excel? [this often prevents link updates]
- I assume by 7-workbook spreadsheet you mean 7-worksheet workbook (ie
a single file)?
- When you say the information is not updated when you open the
workbook and ask for links to be updated, does a typical cell
containing a link formula show an error value such as #REF! or does it
just contain an out of date value?
- Please can you give an example of a formula which does not update
correctly?
(By the way, I like your screen-name!)
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
|