Erin wrote:
Sometimes everybody can see the questions/answers,
sometimes not. When the linked info isn't visible, there
is no error message.


Is it just that you are not seeing changes that have been made to other
files since you opened the file you are looking at?

That would be normal behaviour.
To see the changes the changes would need to have been saved and then
you would need to update the links (Edit / Links / Update Now)

Otherwise:
- what answer did you give to the "update links" dialog on opening the
workbook
- what is your calculation mode (Tools / Options / Calculation)


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup