Chance224 wrote:
Example cell D3 on the summary sheet would be
=Blank14!$C$3 if you go and
change the linked employee's sheets name, cell D3 will only update if you
double click the cell.


When you say the cell only updates if you double-click it, do you mean the
formula bar still shows the old formula (containing "Blank14!")? That would
not be normal behaviour unless Excel was still busy recalculating everything
as a result of the sheet name change and hadn't quite got round to updating
the screen.

Are there macros in this workbook?

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