Cell update???
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 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 |
All times are GMT +1. The time now is 02:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com