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

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,801 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jiajing Hua-MFST 15,875 Reputation points Microsoft External Staff
    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.

    0 comments

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.