Share via

Using formula in Excel - having entered the formula how do I get to display the answer so it updates when I change the data

ian matthews 0 Reputation points
2025-03-11T14:22:43.5033333+00:00

Setting up formula in a workbook. Formula is correct and I want to display the result but without impacting on the formula - which I want to update automatically whenever I change the data

Microsoft 365 and Office Excel For business Windows
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jiajing Hua 18,060 Reputation points Moderator
    2025-03-12T01:37:48.7766667+00:00

    Hi @ian matthews

    If you have set Automatic Workbook for Calculation, the result will be updated automatically when you change the data referenced in formula.

    • Please go to Files > Options > Formulas, select Automatic for Workbook Calculation. User's image

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.