I have a workbook template where I have one (1) instance of a circular reference that I WANT. I have selected Maximum iterations=1. The cirucular reference is used for a timestamp of a signature. However when the workbook is saved and reopened I have to once again check this off and then the time entered does NOT reflect the original time. Here is the circular formula I am using, =IF(G17<>"",IF(K17="",NOW(),K17),"").
I went into Options, formula, and enabled Iterative calculations to "1". So can someone tell me why this is not being saved properly???
Thank you again for your help in this matter...
I went into Options, formula, and enabled Iterative calculations to "1". So can someone tell me why this is not being saved properly???
Thank you again for your help in this matter...