Share via

How to update real time in excel

Anonymous
2018-02-04T20:12:51+00:00

We were told to remake this excel file. The sheet should update the numerical information when a number is given above(like 152 on the image). We are supposed to fetch data and from a different work sheet and display the sum in the boxes. How can I do it?

Microsoft 365 and Office | Excel | For home | 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

25 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. DaveM121 816.4K Reputation points Independent Advisor
    2018-02-04T20:18:30+00:00

    Hi Sabir,

    If you Press F9 does the sheet Update?

    If it does:

    Go to File - Options

    Cick Formulas and Set Calculate options to Automatic

    If not, have you entered the correct formula in the appropriate cells?

    Which cells are not updating?

    Upload a copy of the Spreadsheet to the Cloud (OneDrive, DropBox . . . etc.), then post a link here and I will have a look for you . . .

    0 comments
  2. Anonymous
    2018-02-04T20:24:56+00:00
    0 comments
  3. DaveM121 816.4K Reputation points Independent Advisor
    2018-02-04T20:26:24+00:00

    Hi Sabir that link is not working (file no longer available), please try again . . .

    0 comments
  4. Anonymous
    2018-02-05T06:15:01+00:00
    0 comments
  5. DaveM121 816.4K Reputation points Independent Advisor
    2018-02-05T08:11:22+00:00

    OK got the sheet, I am at work, I will have a look in about 2 hours and get back to you . . .

    0 comments