Enable Iterative Calculations

Joined
Sep 6, 2016
Messages
1
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top