Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Name field - automatic calculate
I have a formula stored in a name field on sheet "a"
When I change an item on sheet "b"; the item on sheet "a" does not change automatically. The only way to get it to change is to go the field on sheet "a" and press enter. What's the point of using name fields, if they don't recalculate? I even tried pressing F9. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Name field - automatic calculate
Please post your formulas and explain what you mean with "name field"
-- Kind regards, Niek Otten Microsoft MVP - Excel "notso" wrote in message ... |I have a formula stored in a name field on sheet "a" | When I change an item on sheet "b"; the item on sheet "a" does not change | automatically. The only way to get it to change is to go the field on sheet | "a" and press enter. | | What's the point of using name fields, if they don't recalculate? I even | tried pressing F9. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Name field - automatic calculate
I have defined a formula as a name; and was not getting the results expected.
I figured it out, the address in the name was off by one column. Sorry. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate PivotTable Item Totals Based On Cell Contents? | Excel Worksheet Functions | |||
Pivottable adding calculated field? | Charts and Charting in Excel | |||
Pivot table calc using average in summed field | Excel Discussion (Misc queries) | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) | |||
Pivot Tables..I give up... | Excel Worksheet Functions |