Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Why wouldn't the formula cells get dynamically calculated when target cell
data is changed? Couldn't find anything about this in help files. I have been using this worksheet for years and never saw this problem... a simple 2-week payperiod timesheet ... Fourteen pair of cells in which I enter start time and end time, and fourteen cells with a formula to compute hours worked per day (difference between the daily pair). Also weekly and biweekly totals. The cells all calculated when I "saved" the file. Also when I closed/reopened, it still won't evaluate the formula cell(s) when I change a "data" cell. Only if I hit "save", or individually select each formula cell, place the cursor in the function box, and press enter. 1) What happened? 2) What can I do to fix it. 3) Is there a command that I can run to "calculate all" functions in a sheet (or workbook)? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula evaluation | New Users to Excel | |||
Target cell reference moves when target is cut and pasted | Excel Discussion (Misc queries) | |||
What formula will copy the content & format of the target cell? | Excel Discussion (Misc queries) | |||
I want to hide values if no data in target cell | Excel Worksheet Functions | |||
formula to lookup value and return value from cell at left of target | Excel Worksheet Functions |