The formula bar still has the old sheet name it. If you double click the
cell as if you where to edit it and then press enter it will update the cell.
Thre are a couple of macro's but they are just short cuts to select a
certain sheet. This seem sto be really wierd error. We have tried this file
on several different computers to see if it was a ram issue. Thanks for any
furthur assistance.

Chance

"Bill Manville" wrote:

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