Hello,

I am having this annnnnoying problem with Excel (2007 and 2003). I have a
user defined function in my workbook. The function works fine (well unless
it's not working fine, but I'm getting the results I want from the function).
Except once a while, especially if close and open file, the cell containing
the user defined function just displays "#REF!"..... Now if I double click
the cell, and then press enter, it's back to working as usual.... and the
cycle goes on...... Is there a way to somehow refresh automatically? Shift-F9
not working...

Thanks in advance