It sounds like you have calculation set to manual.

Try checking under the Tools|Options|Calculation tab


Chance224 wrote:

We are using a workbook for our payroll. The file has aheet with every
employyees name plus a summary page. The file is 5.67MB. The summary page
is linked to each employee sheet. example cell D3 would be =Blank14!$C$3. Is
you go and change the sheet name cell D3 will only update if you double click
the cell. Is there a way to have it auto update?

Thanks,
Chance

--

Dave Peterson