Name field - automatic calculate

[Guest]

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.

 

[Niek Otten]

Please post your formulas and explain what you mean with "name field"

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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.

 

[Guest]

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.