| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) | |||
| How does one update and transfer values between cells and not the. | Excel Discussion (Misc queries) | |||
| How do I get one cell to record the time another cell was changed. | Excel Discussion (Misc queries) | |||
| Timestamp cell to left after update | Excel Discussion (Misc queries) | |||
Linear Mode
