Naimul Hasan Arif
In terms of working with Excel, we face different kinds of problems on different occasions. One of the weirdest problems is Excel cells not updating unless double click. No matter how weird the problem is, there are always some solutions to it. I will explain 5 smooth solutions to this problem.
For more clarification, I am going to use a dataset containing columns Company and Market Value in Billions.
Download Practice Workbook
Reasons for Cells Not Updating Unless Double Click in Excel
Before going to the solutions, let’s talk about the problem first. There are many reasons which could lead to the issue of Excel cells not updating unless double click. Some of them are written below:
- Calculation Options not set in Automatic mode
- Use of Space before the formula
- Use of Apostrophe in the equation
- Turning ON the Show Formulas
- Cell Format not set properly
These could lead to the issue of Excel cells not updating unless double click.
5 Smooth Solutions to Excel Cells Not Updating Unless Double Click Issue
1. Setting Calculation Options to Automatic
A very easy solution to the problem of Excel cells not updating unless double click is to set the Calculation Options to Automatic mode.
Steps:
- Go to the Formulas.
- Click on Calculation Options.
- Now, set it to Automatic.
- Now, work with any of your cells.
I input the following formula:
=SUM(C5:C10)Here, I found out the Total Value with the SUM Function from cells C5 to C10.
- Hit ENTER.
We can see that it works perfectly and double clicking problem is resolved.
Read More: How to Auto Refresh Pivot Table without VBA in Excel (3 Smart Methods)
2. Removal of Space before Equal in Case of Formula
Putting a space before a formula could lead to some uncharacteristic behaviour. Cells not updating unless double click is one of a kind. We need to remove the space before the equal to solve the problem.
Steps:
- Input a formula in your preferred cell without an equal before the formula.
I input the following formula in cell C11:
=AVERAGE(C5:C10)Here, I have applied the AVERAGE Function to find out the average from C5 to C10 cells without an equal before the formula.
- Press ENTER.
Thus, we can have our output without double clicking.
Read More: [Solved]: Excel Formulas Not Updating Until Save (6 Possible Solutions)
Similar Readings
- How to Disable Background Refresh in Excel (2 Handy Methods)
- How to Disable Background Refresh in Excel (2 Handy Methods)
- How to Refresh Chart in Excel (2 Effective Ways)
3. Elimination of Apostrophe in Case of Formula
An Apostrophe in an equation symbolizes text value. So, if we use it in an equation where it is not needed, it might create disruption in the output cells not updating unless double click may be one kind of a problem. In order to solve the problem follow the following instructions.
Steps:
- Write a formula without using an apostrophe.
I input the following formula in cell C11 without using an apostrophe:
=SUM(C5:C10)Here, I found out the Total Value with the SUM Function from cells C5 to C10.
- Now, press on ENTER.
We can see that it works just how I give the instructions.
4. Turning Off Show Formulas Button
Keeping the Show Formulas option turned on could get you into some serious trouble. One of them is cells not updating unless double click. Follow the following instructions in order to solve the problem.
Steps:
- First of all, input a formula in your preferred cell.
I input the following formula in cell C11:
=AVERAGE(C5:C10)Where, I have applied the AVERAGE Function to find out the average from C5 to C10 cells.
- Next, hit ENTER.
We can see that the output shows the equation only.
- Now, click on Formulas.
- Then, press on Show Formulas from the ribbon.
Now, we can see that our problem is solved.
5. Changing Format of Cells
Due to the setting of Number Format, we sometimes do not get our desired output. Then, we need to fix the Number Format to have our desired result.
Steps:
- Apply a formula in your preferred cell.
I applied the following formula in cell C11:
=SUM(C5:C10)Where, I calculated the Total Value with the SUM Function from cells C5 to C10.
- Now, click on the Home tab.
- From there, select the Number Format.
- Choose a number format according to your choice. I selected Accounting Format.
We can see that the selected number format is applied to the cell without double clicking.
Conclusion
I have tried to explain 5 smooth solutions on Excel cells not updating unless double click problem. I hope it will help the Excel Users. For further queries, comment below.
