I know this is a long shot but here goes. I have 2 sheets: a calculation/capture sheet and a reference date calculation sheet. The first gets information from a web form and does a few on-sheet look-ups and calculations. Two pieces of data are pushed to the second sheet where date calculations occurr and the 3 resulting date sets are returned to their own fields/columns on the first sheet.
The weird thing is if I erase the formulas in the fields currently showing Circular Reference Error and press save, they work! Until I close the sheet or press Refresh. Why do they work sometimes and not after?? Any help or advice would be wonderful.
Attached are screen shots of the 2 sheets and all formulas being used.
