Not quite clear what the situation is.

You talk about 2 worksheets - in the same workbook?
Or do you mean 2 separate workbooks?

What is the formula in the cells containing the links?

What is your calculation mode (Tools / Options / Calculation) ?

Which version of Excel?

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