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**.

**Table of Contents**hide

## 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. **C****ells 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.