How to enable iterative calculation in online excel ?

Anonymous
2021-07-30T10:53:53+00:00

Once we enable the iterative option from Formula and upload it in online excel, the result is showing individualy, if i updated and a got a result only i can see the result , in next users cell its just showing blank.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Anonymous
    2021-07-30T12:08:56+00:00

    Hi Sethu,

    We are sorry to convey that this feature is not supported in Excel for Web. You can click "Open in Excel" to user it efficiently.

    For more information, you can refer to this article: Change formula recalculation, iteration, or precision in Excel - Excel (microsoft.com) Appreciate your understanding.

    Best Regards,

    Ivy

    4 people found this answer helpful.
    0 comments No comments
  2. Anonymous
    2021-07-30T21:05:28+00:00

    Can you suggest an alternative, my requirement is once the user enters data I need to know when the user enters it. Like a kind time stamp for data entry.

    6 people found this answer helpful.
    0 comments No comments
  3. Anonymous
    2021-07-31T09:13:37+00:00

    Hi Sethu,

    I don't think there is an alternative way to meet your requirement. I will keep this thread open and welcome all the community members to share their suggestions here. Hope it will help somehow.

    Best Regards,

    Ivy

    2 people found this answer helpful.
    0 comments No comments