Enable Iterative Calculations

Discussion in 'Excel' started by Kim R-B, Sep 6, 2016.

  1. Kim R-B

    Kim R-B

    Joined:
    Sep 6, 2016
    Messages:
    1
    Likes Received:
    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
     
    Kim R-B, Sep 6, 2016
    #1
    1. Advertisements

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.