Cell update???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
It sounds like you have calculation set to manual.

Try checking under the Tools|Options|Calculation tab
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linked cell auto update??? 3
Help to create a macro 2
create a summary page that will take a list and remove empty rows 3
Copying from different files into 1 1
excel workbooks 1
Possible? Copy/paste to&from moving sources/destinations 2
Excel 2007 - referencing a cell value from another worksheet withi 6
Populate Data from Summary Sheet 5

Back
Top