Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android, and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of the Microsoft Office suite of software.

Fix: Excel Formulas Not Updating - 1

Excel Logo

Usually, the formulas are automatically updated when the user presses enter or click out of the cell, However, quite recently a lot of reports have been coming in about the program not updating the formulas automatically and the formulas not updating when dragged. In this article, we will discuss the cause of the problem and provide you with viable solutions to solve the problem.

What Causes the Formulas to not Update automatically?

The causes of the problem are pretty simple and straight forward

  • Formula Settings: Sometimes, when you save a spreadsheet and exit the application the formula settings get reset. When you load the save file again the formula settings are sometimes set to be updated manually. This means that the formula cells will only update if you manually update them.
  • Format: In some cases, it was found that if the cell format of your formula is set to “Text” instead of “General” then the formulas will not update.
  • Mistyping: If there is a space in the start of the formula then the program will not detect it as a formula and just as simple text, therefore, it will not update. Also, sometimes there is an apostrophe at the start of the formula. This apostrophe cannot be seen unless you double click on the cell
  • Show Formula Button: Also, if the “Show Formula” button is toggled on the sheet you are currently working on or any other sheet it will show you the formula instead of the result. Thus, your formula won’t update.

Now that you have a basic understanding of the nature of the issue we will move on towards the solutions.

Solution 1: Changing Update Settings.

Sometimes, when you save a spreadsheet and exit the application the formula settings get reset. When you load the save file again the formula settings are sometimes set to be updated manually. This means that the formula cells will only update if you manually update them. In this step, we are going to be changing that setting

  1. Click on the Formulas tab on the top of the window . Clicking on the Formulas Tab
  2. Select the “ Calculation Options ” button on the right side. Selecting Calculation Options
  3. Select “ Automatic ” instead of “ Manual “. Selecting Automatic
  4. Try to update your formulas now and see if they work.

Solution 2: Changing Format of Cell

In some cases, it was found that if the cell format of your formula is set to “Text” instead of “General” then the formulas will not update. Therefore, in this step, we will be changing the format of the Formulas.

  1. Select the cell with the formula in it
  2. Click on the Home tab on the top of the window Clicking on Home
  3. Inside the “ Numbers Format ” settings in the middle of the window, select “ General ” instead of text .
  4. Double – Click on the Formula cell again and press “ Enter ” to update the formula automatically

Solution 3: Checking for Mistypes

If there is a space in the start of the formula then the program will not detect it as a formula and just as simple text, therefore, it will not update. Also, sometimes there is an apostrophe at the start of the formula. This apostrophe cannot be seen unless you double click on the cell. In this step, we are going to make sure that there are no mistypes.

  1. Double – Click on your formula cell
  2. If an apostrophe or space appears up before the formula delete it. Space behind the Formula Apostrophe behind the formula
  3. Click out of your cell and Double – Click on it again
  4. Press Enter to update the cell

Solution 4: Disabling “Show Formula” Setting

Also, if the “Show Formula” button is toggled on the sheet you are currently working on or any other sheet it will show you the formula instead of the result. Thus, your formula won’t update. In this step, we will be disabling that option.

  1. Click on the Formulas tab on the top of the page Clicking on the Formulas Tab
  2. Inside that, on the right side, there will be a “ Show Formulas ” button Disable the “Show Formulas” Tab
  3. Make sure that the option is not enabled
  4. On the bottom left, if there are any other Sheets opened up instead of the one you are working on, make sure that the “ Show Formulas ” button is disabled on them also.
  5. Now Double – Click on your Formula cell and press “ Enter “

How to Fix “Printer is in an error state” Issue?

The error “ WinRAR Error: Next Volume Is Required ” usually appears when you’re extracting a multi-part RAR archive and WinRAR can’t find (or can’t correctly identify) the next file in the sequence . This often happens when a volume is missing , stored in a different folder , or renamed in a way that breaks the archive’s expected order .

Fix: Excel Formulas Not Updating - 2

In this guide, we’ll go over the most reliable fixes confirmed by affected users, along with what each method is doing behind the scenes so you can choose the right one for your situation.

Important: To extract multi-volume archives, you should always start extraction from the first file in the set. This is usually file.part1.rar , or (in older sets) the main .rar file that comes before .r01 , .r02 , and so on.

1. Download and Place the Missing RAR File

WinRAR needs all parts of a multi-volume archive to complete extraction. This error usually appears when one of the volumes in a set like .part2.rar , .r01 , .r02 , .001 , and similar naming formats is missing . Downloading the missing volume and placing it in the same folder as the other parts allows WinRAR to continue extracting normally .

  1. Look at the error message or review the list of archive parts in the folder.
  2. Identify which volume is missing (for example, part2.rar , .r02 , .001 , etc.).
  3. Go back to the website or source where you downloaded the archive.
  4. Locate and download the exact missing file using the same naming format as the others.
  5. Make sure the new file name matches the pattern of the rest. Example: If you have file.part1.rar and file.part3.rar , the missing one must be file.part2.rar .
  6. Move the downloaded missing volume into the same folder as the other archive parts.
  7. Confirm that all parts are in a single folder before extracting.
  8. Right-click the first file in the series (usually part1 or the main .rar file) and select Extract Here or Extract to Folder .
  9. WinRAR should now detect all volumes and continue extraction normally .

2. Manually Browse & Select the Next Volume

Use this method only if the next volume already exists , but WinRAR is failing to detect it automatically. This can happen due to incorrect naming , the file being in a different location , or a temporary file access issue. Manually browsing helps WinRAR locate the correct volume and resume extraction without interruption .

  1. Right-click the first file in the series (usually .rar or part1.rar ) and select Extract Here or Extract to Folder .
  2. When WinRAR cannot find the next volume, it will show the “ Next Volume Is Required ” message.
  3. A small window will appear, allowing you to manually select the next volume .
  4. Use the file explorer window to locate the folder where the other archive parts are saved.
  5. Select the next part based on the naming order (example: select file.part2.rar after file.part1.rar ).
  6. Make sure the selected file matches the naming format of the archive (no extra characters like (1) and no mismatched numbering).
  7. WinRAR will resume extraction using the selected volume .
  8. If additional volumes are missing or stored separately, WinRAR may prompt you again. Repeat the same process until extraction completes.

3. Rename the RAR files in Order

WinRAR relies on a proper naming sequence (such as file.part1.rar , file.part2.rar , file.part3.rar ) to extract multi-volume archives. If a file is named incorrectly, contains extra characters, or is out of order, WinRAR may fail to locate the next volume and show this error. Renaming the files correctly helps WinRAR follow the sequence and extract the archive without interruptions .

Note: Renaming only changes the file name , not the file contents. The goal is to restore the correct sequence so WinRAR can detect the next volume.

  1. Go to the folder where all the RAR files are saved.
  2. Make sure all parts of the archive are present and stored in the same folder .
  3. Check how the parts are currently named . Common patterns include:
file.part1.rar, file.part2.rar, file.part3.rar
file.rar, file.r01, file.r02, file.r03
  1. Look for files that don’t match the expected numbering pattern (for example, file.part01.rar , file.part1(1).rar , or unrelated names).
  2. Rename each file so it follows the same order without extra characters or mismatched numbering. Example:
Incorrect: file.part1.rar, file.part3.rar, file.part2(1).rar
Correct: file.part1.rar, file.part2.rar, file.part3.rar
  1. Make sure the text before the number is exactly the same for all files.
  2. Only the last part number should change.
  3. Right-click the first file in the series (usually part1.rar or the main .rar file) and select Extract Here .
  4. WinRAR should now recognize the sequence and continue extraction normally .

If you still get the same prompt: the archive set is likely incomplete (a part was never downloaded or was removed), or one of the volumes is corrupt and must be re-downloaded from the original source.