Fix: Excel Formulas Not Working

Microsoft Excel is a spreadsheet application which has been around for more than three decades and is used by millions of people around the world. It features pivot tables, graphing tools, calculations, and also a macro programming language.

Microsoft Excel also enables the use of formulas through which you can select a sequence of cell values and manipulate them for calculations. If you are a frequent user of Microsoft Excel, you might come across a problem where the formulas don’t work or do not calculate. Don’t worry, this behavior is only because of some settings not set correctly in the application. Take a look.

Solution 1: Check if Formulas are formatted as Text

Cells have the option to set their data type. You can set them to text, numbers, time, dates, etc. It is possible that the cell you are trying to calculate the formula on is set as ‘Text’. We can change the data type of the cell and see if this fixes anything for us.

1. Select the cell where the formula is not being calculated.
2. Now navigate to ‘ Home ’ and here around the middle, you will a drop box consisting of various data types. Select either ‘ General ’ or ‘ Number ’.

1. Now click the cell again and press Enter . This will cause the formula to be calculated automatically and the result will be visible on the cell.

Solution 2: Changing Calculation Options

By practice, changing the calculation option to manual is the best way to minimize the processor usage by the office application. When the calculation type is set to manual, the formulas are calculated not before you save the workbook. When you click the save button, it will perform all the calculation in a batch and then save your work. When the calculation type is set to automatic, all the formulas are calculated in real time. We can change the calculation options and check if this solves the problem for us.

1. Click on ‘ Formulas ’ tab and select the ‘ Calculation Options ’ as ‘ Automatic ’.

1. Restart Excel and check if the problem at hand got solved.

Solution 3: Disabling ‘Show formulas’ options

Excel also has the feature to show the formulas on the cell instead of the calculated value itself. This might be causing for your formulas to work properly but the formula will be displayed on the screen instead of the numeric value. We can try change this option and see if this helps.

1. Click on the ‘ Formulas ’ tab and click “ Show Formulas ” once to disable showing the formulas.

1. Re-open your spreadsheet and check if the problem at hand got solved.

Tips:

• Make sure all opening and closing parentheses match in your worksheet.
• Enter all the required arguments in the formula.
• There is a limit to not nest more than 64 functions in a formula, so make sure you don’t exceed this.
• Do not enclose numbers in double quotes .
• Make sure you are separating function arguments with proper characters. In some regions, you will use ‘,’ to separate while in some you will use ‘;’.
• The workbook and worksheet names should be enclosed in single quotes.
• If using a closed workbook, make sure that the path you write is complete.
• Press Ctrl + Alt + F9 to recalculate all open worksheets.
• You can trim and clean formulas to get rid of extra spacing.
• Keep in mind circular references to avoid getting the formula into an endless loop.
• Make sure you are using the correct way of absolute referencing .

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 .

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.