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.