Update linked cells within a workbook???
 

We are using a workbook for our payroll. The file has aheet with every
employee's name plus a summary page. The file is 5.67MB. The summary page
is linked to each employee sheet. The summary page has 7 rows for each
employee that is linked to the emplyee's sheet. If you move a employee sheet
or rename the sheet the cells linked on the summary page don't automatically
update with ab=ny changes. 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. Is there a way to have it auto update on its own or
with a macro?

Thanks,
Chance

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

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

Which version of Excel?

Does the formula work even though it looks wrong (ie if you update the
source cell does the destination cell also change, assuming automatic
calculation mode)?

If you have Excel 2002 or later try running this macro:

Sub Mend()
Application.CalculateFullRebuild
End Sub

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

The formula will not update even though automatic caculation is selected.
Your macro apprears to be working so far. Thank you very much. It seem that
this is a bug in Excel that won't auto update the calculation. This problem
has stumped many people. Your solution is the best I've seen so far.

Thanks again,
Chance

"Bill Manville" wrote:

Which version of Excel?

Does the formula work even though it looks wrong (ie if you update the
source cell does the destination cell also change, assuming automatic
calculation mode)?

If you have Excel 2002 or later try running this macro:

Sub Mend()
Application.CalculateFullRebuild
End Sub

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