Functions won't update unless "edited"

J

jack0063

I have workbooks with "User Defined" functions. On occasion, when I mak
changes in a workbook, cells calling the function return #Value. If
select the cell, click in the edit bar and hit enter the error goe
away and the correct value is displayed.

Problem is not limited to a particular function or worksheet, but mos
often occurs on relatively complex sheets.

Thanks in advance for any insights..
 
L

Lady Layla

Does F9 work? Do you verify that Auto Calc is on rather than Manual?


:
: I have workbooks with "User Defined" functions. On occasion, when I make
: changes in a workbook, cells calling the function return #Value. If I
: select the cell, click in the edit bar and hit enter the error goes
: away and the correct value is displayed.
:
: Problem is not limited to a particular function or worksheet, but most
: often occurs on relatively complex sheets.
:
: Thanks in advance for any insights...
:
:
: --
: jack0063
: ------------------------------------------------------------------------
: jack0063's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=14671
: View this thread: http://www.excelforum.com/showthread.php?threadid=262915
:
 
Top