Something is amiss. It isn't likely that it is resetting itsel
exactly, but knowing how it's set and if that setting is changing a
all would help narrow down the list of possible answers to you
problem. Just check it when you notice the problem return. See wha
happens when you manualy recalculate (F9). Check to see if there i
any code you don't know about that could be doing that. Assumin
everything is in order then the next liklihood is that the formula i
working, just not in the way you expect it to. - Piku

--
Message posted from http://www.ExcelForum.com