Once Enable iterative calculation (located within Excel Options ->Formulas) has been selected is there any way to prevent the software from turning this feature off?
Using a table within a worksheet I've created a data collection tool that requires the use of circular references to auto number each line and drop date time stamps based on the selections made by the end user. A few times a week the Enable iterative calculation feature has to be re-engaged much to the angst of the end user and management.
Could this issue be related to the software settings on each users computer? Could other spreadsheets, with different settings, the end user is working with cause this problem?
Thank you in advance for your time and assistance.
Kim
Using a table within a worksheet I've created a data collection tool that requires the use of circular references to auto number each line and drop date time stamps based on the selections made by the end user. A few times a week the Enable iterative calculation feature has to be re-engaged much to the angst of the end user and management.
Could this issue be related to the software settings on each users computer? Could other spreadsheets, with different settings, the end user is working with cause this problem?
Thank you in advance for your time and assistance.
Kim