Excel does not update formula promptly

[UriP]

I have HLOOKUP that takes values and looks for result in
other worksheet inside same workbook where it is.
Unfortunately when I change the parametrs in the function
(HLOOKUP) the function does not alway update its result
promptly. Sometimes is dependent of the action from other
VBA written codes behind that have nothing to do with that
particular function and its precedents.
Any idea how to force Excel to update the result from a
function??
Thank you in advance.

 

[Frank Kabel]

Hi
do you use a user defined function. If yes you may post the code. If
you're talking only about worksheet functions check if automatic
calculation is enabled

 

[Guest]

Frank,

Thank You!!
No! It is not a custom function. It is the standard LOOKUP
Excel function.
WHERE DO YOU SET AUTOMATIC CALCULATION ENABLED??
In options menue OR somwhere else??
Thanks,
Uri P.
Oceanside
California

 

[Dave R.]

I can see you are very passionate about this topic. Frank may be away at the
moment, so I'll let you know you find this option under:
tools>options>calculation tab.

 

[Frank Kabel]

Hi
'Tools - Options - Calculate'

 

[UriP]

Thank you gentlemen!
I got it also by my self.
Believeing or not however, the option was set there to
automatic and the excel did not updated the formual. At
one moment on, it started doind so but sometimes it does.
I have seen that in the past when working with it. It
seems to me that when working on the file for long hours,
at one moment Excel stop refreshing. One has to close the
file, open again and only in that moment it starts
refreshing. This happens only with quite complex
calcvulatng files with less data and lots of formulae. I
am quite positive that there is a bug.

What do you think guys?