View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alex Mackenzie Alex Mackenzie is offline
external usenet poster
 
Posts: 14
Default Calculation options change arbitrarily

I have a date stamp function on a spreadsheet to track when people enter
data; it is a function I found on an earlier posting. The function creates a
circular reference, so the iteration checkbox is clicked on the
options/calculation tab. Everything works fine, except, occasionally, for no
reason, the iteration checkbox is cleared! why is this and ow do I stop it
from doing this. Using Excel 2000 on Windows NT.

Thank you.

Alex Mackenzie