How to Fix the
How to Fix the #Value! Error in Excel?
Summary: #Value! is a common error that occurs when using formulas in Excel. It can be due to an issue with the cells you are referencing or use of formulas in the wrong type or format. This blog will discuss some cases when this error may occur and the solutions to fix the issue. You’ll also find about an Excel repair software that can help fix the error if it has occurred due to corruption in Excel file.
You may experience the #Value! error in Excel when trying to enter invalid data type into the formulas. Sometimes, it appears when a value is not the expected type or when dates are given a text value. This Excel error may occur due to several reasons. However, the exact cause of this error is difficult to find. Below, we will be discussing some cases where you may get this error and the solutions to resolve the issues.
Case 1: Wrong Argument Data Type in Formulas
Sometimes, Excel throws the “#Value!” error if it recognizes incompatible arguments in the formulas.
For example: The Date function in the sheet expects only numerical values as arguments. In the below image you can see that when the formula’s string value is used in the month (January), it resulted in the #VALUE! error.
Solution
To fix the issue,
- Double-click the formula to verify the type of arguments.
- Correct the argument in the cell (B2).
The formula will work as expected.
Case 2: Using the Basic Subtraction Formula
Users often experience the #Value! error, when using the basic subtraction formula in Excel.
Solution
Check the formula and the type of values in the cell. If these are correct and the error persists, then follow these steps:
- Go to the Start button on Windows, type Control Panel, and double-click on it.
- Click Clock and Region > Region.
- On the Format tab, click Additional Settings.
- In the Customized Format window, search for List Separator.
- Check if the List Separator is set to minus (-). Change it to comma (,).
- Click OK.
- Now, open the Excel file and again try to use the formula.
Case 3: Wrong Text Value
The #Value! error can also occur due to the formula’s wrong value.
For example: If you are using the formula to add values in cells and Excel recognizes the unexpected text value, you may get a #Value error.
Solution
To fix the issue, you can correct the value or use the SUM function. It is recommended to use functions instead of operations to reduce the errors. In Excel, the formulas with math operators may not able to calculate the text in the cells. The SUM function automatically ignores the text value(er), calculates everything as numbers, and displays the result without the #Value! error.
Case 4: Blank Space in Cells
You may get the #Value! error if your formula refers to other cells with space or hidden space. Sometimes, spaces that make a cell display blank but actually they are not blank.
Solution
You can either delete the space or replace the blank space. Here’s how:
1. Delete the Blank Space
First, check if a cell is blank or not. To do this,
- Select the cell that looks blank.
- Press F2.
The blank cell won’t show space.
Then, press the Backspace key to delete the space. It will fix the error.
2. Replace Blank Space
You can also use the “Find and Select” option to replace the blank space in Excel. Here are the steps:
- Open the Excel file that shows #Value! error.
- On the Home tab, click Find & Select > Replace.
- In the Find what field, type a single space and delete everything in the “Replace with” field.
- Click Replace All > OK.
Case 4: Problem with Network Connection
Many users have reported experiencing errors when using Excel online due to problems with the network connection.
Solution
Check your Internet connection and see if it is working properly.
Case 5: Wrong Formula Format
If you enter the wrong formula with a missing parenthesis or comma, then Excel can throw the #Value! error. The error can also occur if the application finds a special character within a cell.
Solution
Correct the formula and use the ISTEXT function to find the cells with issues.
Case 6: Corruption in the Excel File
If none of the above works, then it indicates the Excel file is corrupt. The formulas in the Excel file do not work due to corruption.
Solution
You can use the Open and Repair utility in Excel if you are getting the error due to corruption in Excel file. In case the utility fails or the Excel file is severely corrupt, you can use a third-party Excel repair software, such as Stellar Repair for Excel. It is a powerful tool to repair corrupted or damaged Excel files and recover all its data, with 100% integrity. The tool supports Excel 2019, 2016, and older versions.
Closure
There are several reasons that can trigger Excel to throw the #Value! error. It can occur if there is an incorrect argument data type in formulas or blank space, text, or special characters within a cell. This blog discussed the possible scenarios when this error occurs. You can apply the solutions mentioned above to fix the error. If the #Value! error occurs due to corruption in the Excel file, then you can use Stellar Repair for Excel . It is a reliable tool that helps in fixing corruption-related errors in Excel.
How to fix Microsoft Excel has stopped working error?
Summary: This blog discusses the possible reasons behind ‘Microsoft Excel has stopped working’ error and solutions to resolve the error manually. You can use Stellar Repair for Excel to quickly repair the file and recover all its data in a hassle-free manner.
Has your Microsoft Excel program stopped working or is acting strange? Excel not responding is a common issue you may experience on launching the application or opening a spreadsheet.
Figure 1 – Microsoft Excel Has Stopped Working Error Message
Possible Causes behind ‘Microsoft Excel has Stopped Working’ Error, and Solutions Thereof
Note: Several users have reported about encountering the ‘Excel has stopped working’ issue on Windows 10, 8, and 7 OS after installing an update for Excel (KB3118373). If you too have installed the update, then uninstall it and check if it solves the error. For detailed information, refer to this link .
How to repair ‘recovered’ Excel file that won’t open
Summary: You may unable to open the Excel file after file recovery. When you try to open the file you may prompt up with error messages. This blog will discuss those errors and their solutions. Besides this, it also mentions Stellar Repair for Excel to repair and recover the severely corrupted Excel file with no data loss.
Consider a scenario: A Windows 10 user accidentally deletes a folder containing multiple Excel (XLSX) files created in Excel 2013. The worst part was all the deleted files were important, and he did not have a backup, which would help him in restoring the data. Nonetheless, he was able to recover those data using a professional data recovery software. Next, he tried opening each of the recovered Excel files one by one. In doing so, his happiness turned into disappointment. And the reason was, some of the recovered Excel files failed to open prompting error messages, of course, due to corruption. In this scenario, all he needed was to repair ‘recovered’ Excel files that did not open. Know how to fix damaged Excel files that were recovered after deletion in this blog!
Before delving into the Excel file repair methods, acquaint yourself with the probable causes leading to damaged or corrupt Excel files. Although not essential, it shall be an added advantage in helping you to prevent Excel file corruption issues in the future.
The standard Excel file(s) Corruption Causes
- Power Outage – A power outage due to which a system closes suddenly or unexpectedly is a common cause of damaged Excel files.
- Forced System Shutdown – Shutting down the system forcibly without closing MS Excel files is another common cause of corrupt Excel files.
- PC Virus or Bug – Computer viruses or bugs may affect one or more data file if owners do not protect their PCs with powerful updated antivirus. Same is the case with malware attacks. The chances are that your computer is infected with one of these and has affected a few Excel files.
- Issues with Storage Devices – Damaged or corrupted Excel files can also be the outcome of hard drive issues in the data storage systems. Logical hard drive damage is one of the most significant issues.
The damaged Excel files may prompt up with error messages. These may be:
- ‘Excel unable to read file’
- ‘Filename is not valid’
- ‘This file is not in a recognizable format’
- ‘abc.xls file cannot be accessed. The file may be read-only’
- ‘Excel found unreadable content in (filename)’, ‘The file is corrupt and cannot be opened’
- ‘Microsoft Excel has encountered a problem and needs to close’
There exist multiple methods to repair Excel files which got damaged after recovery, and are as follows: XML method,
- Open Excel files with HTML
- Inbuilt ‘Open and Repair’ feature/tool in Excel
- Repair damaged Excel file from TMP file by using Excel AutoRecover and AutoBackup features
- Recover data by configuring ‘calculation option’ as manual
- Moving/copying or transferring data to a different location
- Stellar Repair for Excel software
Taking Stellar software versus other methods, the former is a software solution that repairs damaged (XLS and XLSX) file quickly in major three steps: Select->Repair->Save, whereas others fall into the category of manual processes and consume both time and resources. Among the manual processes ‘Open and Repair’ method is the least time and resource consuming, which you can try quickly by following the below steps:
Open and Repair method
- Click MS Excel tab and then the Open tab
- Select the damaged Excel file for repairing purpose
- Click the arrow present beside the Open Next, click Open and Repair tab
- Click either of the following:
- Repair tab (recovers maximum data)
- Extract Data tab (Recovers values and formulas if the repair process fails in recovering the complete data.)
Note – Use ‘Extract Data’ if ‘Repair’ is not successful.
If the Manual method is not competent enough to repair recovered Excel files that don’t open then opt for a software-based solution of deploying Stellar Repair for Excel software.
Software with 100% integrity and precision
Conclusion
As an automated software, Stellar Repair for Excel is easy-to-use. You do not need technical know-how and skill set, as required to execute the manual processes. On analyzing all these methods, it is suggested to use Stellar Repair for Excel having a user-friendly GUI to repair Excel files that became damaged after recovery, or if the recovered Excel file(s) that you once deleted accidentally has become corrupt now. Above all, it is an excellent software with multiple features and advantages. Use it to address all your MS Excel issues or if any recovered Excel file is corrupt.
Excel Repair Tool to Repair Corrupt Excel files (.XLS/.XLSX)
When to Use Stellar Excel File Repair Tool?
Unable to Open an Excel File Due to Invalid Extension?
You may face an error - “Excel cannot open the file .xlsx” in Excel 2021, 2019, 2016, etc., leading to data loss. This error occurs when you try to open corrupt Excel file or an invalid file format. Using the correct extension can resolve the issue, if there is no corruption. However, you need an Excel repair tool if the file is corrupt. Stellar Repair for Excel can repair the corrupt file and recover all objects in intact form.
Excel File Not Opening Due to Corruption?
You cannot open an Excel file if it is corrupted. For example, opening an Excel file created in a lower version like Excel 2007 in Excel 2010 or later version can throw a corruption error message. Or, the file may open in a ‘protected view,’ not allowing any write operations. The Excel repair tool from Stellar provides a comprehensive solution to fix corrupt Excel files across all versions, including Excel 2021, 2019, 2016, 2013, and older.
Excel Found Unreadable Content?
You may encounter an error message – “Excel found unreadable content in filename.xls”, with a message to recover the contents of the workbook. Clicking ‘Yes’ to recover the contents may lead to loss of formatting, replacement of formulas, and inconsistencies. Stellar Phoenix Excel Repair software now Stellar Repair for Excel can scan the workbook and recover its contents.
KEY FEATURES FOR REPAIR FOR EXCEL
Software Important Capabilities
Repair Large-sized Excel Files
Stellar Repair for Excel software previously known as Stellar Phoenix Excel Repair can repair & fix corrupt Excel files of any size. It removes corruption from individual objects, fixes the damage, and restores the Excel file back to its original state. The Excel repair tool can repair multiple Excel files in a batch.
Learn More
Resolves All Excel Corruption Errors
This Excel file repair tool fixes all types of Excel corruption errors, such as unrecognizable format, Excel found unreadable content in name.xls, Excel cannot open the file filename.xlsx, file name is not valid, the Excel file is corrupt and cannot be opened, etc. It provides a comprehensive solution for fixing Excel file issues.
Learn More
Preview the Repaired Excel File
The software shows a preview of the repaired Excel file and its recoverable contents in the main interface. This functionality allows you to verify the data in your repaired Excel file, including all of its objects, before saving the file. The Excel File Recovery software helps in determining the final state of data you will receive after repairing the corrupted Excel file.
Learn More
Recovers All Excel file Objects
The software repairs the corrupt Excel file and recovers all objects, including tables, charts, series trendline, conditional formatting rules, and properties of the worksheet. The software also recovers embedded functions, group & subtotal, engineering formulas, numbers, texts, rules, etc. It recovers Excel file data in its intact form.
Reviews & Feedback
Recommendation by Microsoft MVPs
OTHER IMPORTANT FEATURES
Know your Product Better
Option to Find Excel Files
Stellar Excel repair software helps users unaware of the Excel file location to search for all the Excel files on the computer. It provides ‘Find’ option to quickly locate and list all the Excel files for repair. You can select single or multiple files from the list that you want to repair.
Stellar Toolkit for File Repair
Stellar Toolkit for File Repair provides essential tools to repair corrupt Office files via a single interface. It comprises tools like MS Excel Repair, MS Word Repair, MS PowerPoint Repair, and PDF Repair to fix corrupt documents while maintaining the original file format.
Learn More
HOW TO USE STELLAR REPAIR FOR EXCEL
Screenshots & Video
PRICING
Choose The Best Plan
Excel Repair
Repairs corrupted Excel files with 100% integrity.
- Repairs XLS, XLSX, XLTM, XLTX, and XLSM files
- Repairs multiple Excel files
- Previews the repaired file
- Supports Excel 2021 & older versions
File Repair Toolkit
Repairs corrupted Excel, Word, PowerPoint, & PDF files.
- Repairs XLS, XLSX, XLTM, XLTX, and XLSM files
- Repairs multiple files
- Previews the repaired file
- Supports Excel 2021 & older versions
- Repairs .DOC & .DOCX files
- Repairs .PPT, .PPTX, & .PPTM files
- Repairs corrupted PDF file
Best Seller
File Repair Toolkit Technician
Repairs corrupted Excel, Word, PowerPoint, & PDF files up to 3 systems.
- Repairs XLS, XLSX, XLTM, XLTX, and XLSM files
- Repairs multiple files
- Previews the repaired file
- Supports Excel 2021 & older versions
- Repairs .DOC & .DOCX files
- Repairs .PPT, .PPTX, & .PPTM files
- Repairs corrupted PDF file
CUSTOMER REVIEWS
You’re in Good Hands
AWARDS & REVIEWS
Most tested. Most awarded
DATA SHEET
Technical Specifications
About Product
Stellar Repair for Excel
Version: | 6.0.0.7 |
License: | Single System |
Edition: | Standard, Technician, & Toolkit |
Language Supported: | English |
Release Date: | February, 2024 |
Processor: | Intel compatible (x64-based processor) |
Memory: | 4 GB minimum (8 GB recommended) |
Hard Disk: | 250 MB of Free Space |
Operating System: (64 Bit only) | Windows 11, 10, 8.1, 8, 7 |
USEFUL ARTICLES
Product Related Articles
How do I repair multiple Excel files by using Stellar Repair for Excel software?
After launching the software, click Select File button in the Home tab. Next, click Browse and select the checkbox against all the Excel files you need to repair. Then, click the Repair button to start repairing all the Excel files.
How do I see the Preview of repaired Excel file using the Demo version of the software?
Browse and select the file(s) to repair. The software will start scanning the Excel files once you click the Repair button. Next, it will display the files in the left pane. You can preview their contents in the right pane.
How do I find the recovered Excel file?
The software saves the repaired file with the prefix “Recovered” at the user-specified location. You can find the recovered file using the Search box utility in the taskbar.
Start Using Stellar Repair for Excel Today
- Trusted by Millions of Users
- Awarded by Top Tech Media
- 100% Safe & Secure to Use
Free download to scan and preview all recoverable Excel data.
Ways to Fix Personal Macro Workbook not Opening Issue
Many users have reported encountering issues while accessing personal macro workbook, such as personal macro workbook not opening, personal macro workbook not loading automatically, Excel personal macro workbook keeps getting disabled, etc.
Such issues may arise due to a problem with the directory where the personal workbook is stored. However, there are various other reasons that may lead to such issues. Below, we’ll discuss the reasons behind the personal macro workbook not opening issue and the solutions to troubleshoot and fix the issue. But before proceeding, let’s understand why personal macro workbook is used.
Why Personal Macro Workbook is used?
You can access macros in a specific Excel workbook. However, when you need to use the same macro in other Excel worksheets, then you can create a personal macro workbook. A personal macro workbook (Personal.xlsb) is a hidden workbook that is used to store all macros. It makes your macros available every time you open Excel.
Causes of Personal Macro Workbook not Opening Issue
You may encounter personal macro workbook is not opening issue when attempting to record macros. Some possible causes behind such an issue are:
- Personal macro workbook is stored at an untrusted location
- Location of xlsb is changed
- Personal macro workbook is hidden
- Personal macro workbook becomes corrupted
- Disabled items in add-ins
- Workbook is Read-only
Methods to Fix the “Personal Macro Workbook not Opening” Issue
Follow the given methods to fix the personal macro workbook is not opening issue:
Method 1: Check the Path of Personal.xlsb
The personal macro workbook (Personal.xlsb) file is stored in XLStart folder. It opens automatically when you open your Excel application. However, sometimes it fails to load automatically. It usually occurs when you try to open the file from an incorrect path. You can check the path of Personal.xlsb by following these steps:
- Open the workbook.
- Click on the Developer tab.
- Press Alt + F11 to open Visual Basic Editor.
- Go to View > Immediate Window.
- In Immediate Window, type the following code to know the location of the workbook:
?thisworkbook.path.
- Then, hit Enter.
- You will see the path of the personal macro workbook.
- Copy the path and paste it into Quick Access field in File Explorer.
Method 2: Unhide Personal Macro Workbook
If personal macro workbook is hidden, you may unable to see and open the Personal.xlsb file. To unhide the personal Macro workbook, follow the below steps:
- In Microsoft Excel, go to View and then click Unhide
- The Unhide dialog box is displayed. Click PERSONAL and then OK.
Method 3: Enable the Macro Add-ins
You may unable to open the previously recorded macros in your personal macro workbook if the macros are disabled. To check and enable the items, follow these steps:
- Go to File > Options.
- In Excel Options, click on the Add-ins
- Select Disabled Items from the Manage section and click on Go.
- The Disabled Items dialog box appears. Click on the disabled item and then click Enable.
Method 4: Change the Trusted Location
You may encounter the “personal macro workbook not opening” issue if the Personal.xlsb file is stored at an untrusted location. You can check and modify the path of XLSTART folder using the Trust Center window. Here are the steps:
- Open MS Excel. Go to File > Options.
- Click Trust Center > Trust Center Settings.
- In the Trust Center Settings dialog box, click on Trusted Locations.
- Verify the path of the XLSTART If it is untrusted or there is any issue, then click Modify and then click OK.
Method 5: Repair your Excel File
You may fail to open personal macro workbook if it is corrupted. To repair the corrupt workbook, you can use the built-in Open and Repair utility in MS Excel. To use this tool, follow these steps:
- Open your Excel application.
- Click File > Open.
- Browse to the location where the corrupted file is stored.
- In the Open dialog box, select the corrupted workbook.
- From the Open dropdown list, click Open and Repair.
The dialog box appears with the Repair and Extract buttons. Click Repair to retrieve all possible data or the Extract option to recover the data without formulas and values.
If the Open and Repair utility fails to repair the corrupted Excel workbook, then you can use a professional Excel repair tool, such as Stellar Repair for Excel. It can easily repair severely corrupted Excel (XLSX and XLS) files and recover all the components. You can download the free trial version of the tool to preview the recoverable data.
Closure
This article discussed the ways to fix the personal macro workbook not opening issue. In case you are unable to open the personal macro workbook because of corruption in the workbook, you can use the Open and Repair utility in MS Excel. If it fails, then you can use Stellar Repair for Excel to fix corruption in the Excel file and recover all its data with complete integrity.
4 Ways to extract data from corrupt Excel file
Summary: Excel files can become corrupt due to numerous reasons. This blog will discuss the reasons behind the corrupted Excel files. Sometimes the file becomes inaccessible. This post includes four ways to extract data from a corrupt Excel file. It also mentioned Stellar Repair for Excel to repair severely corrupted files. The tool helps you recover data from damaged Excel files with complete integrity.
Imagine the frustration of an employee if an Excel workbook he took hours to complete became corrupted for some reason threatening to erase all the data saved in it. Not just that, a corrupted Excel workbook can wreak havoc for the organization too since it poses a risk of permanently deleting critical business information like work records or employee trackers.
Unless a backup of all important Excel files exists, recovering data lost due to damage/corruption to them is next to impossible. However, we’ve conducted some research and found some pretty neat hacks to help you extract data from corrupt excel files without much hassle.
Primary reasons triggering Excel file corruption
As we always point out, to solve a problem for good, getting to its root is imperative. Here are the main reasons that cause Excel file corruption. Knowing these reasons can help you keep Excel corruption at bay for a considerably long time.
- Abrupt system shutdown when you’re editing an Excel sheet
- Bugs / Defects in your Excel application or installation
- Hardware failures like bad sectors on the hard drive where Excel sheets are saved
- Virus Infection / Malware Attack
- Excessive data storage within a single Excel file
- Faulty Excel Macros and CSE Formulas
Depending upon the extent of damage, there can be several ways to perform corrupt Excel file repair.
How to repair corrupt Excel files?
There are a couple of manual methods that can help you repair corrupt Excel files .
- If the damaged Excel sheet can be opened, immediately save its copy; thereafter:
- Open it with a later version of Excel and save it as a new workbook.
- If this doesn’t work, open it in Excel’s latest version and save the workbook in HTML or HTM format.
- Once this is done, reopen the HTML file and save again in XLS format.
- Lastly, open the file and try saving it in SLK format (symbolic link)
Note: It is important to note that saving an Excel workbook in HTML format causes loss of features like custom views, scenarios, unused styles or number formats, natural language formulas, data consolidation settings, custom function categories, etc. In SYLK format only the active worksheet is saved so if using this method, you’ll need to repeat these steps for each worksheet.
- Use Excel’s inbuilt Repair function as follows:
- Launch Microsoft Excel and go to Office button -> Open
- In the Open dialog box, select the damaged Excel file
- On the bottom-right corner of the Open dialog box, you will find a drop-down next to Open Click on it and select Open and Repair
- This will launch the inbuilt Repair module of Excel and you’ll see a dialog box asking you to select an option from Repair or Extract Data
- Click on Repair to initiate the repair process.
- If this doesn’t work, repeat steps 1-4, and when Excel asks you to select an option, select Extract Data from corrupt excel file. Thereafter, follow the instruction Excel shows and you should be able to retrieve your data, but you may end up losing some formulas.
- If you cannot open the Excel, download Spreadsheet viewer from the Microsoft website and open the file using this program. Thereafter copy all data into a new Excel.
Note: This method will cause much of your formatting, formulas, and more to be lost.
- You can download Open Office from its official website OpenOffice.org and try opening the Excel in it. The two programs are very similar so all data should automatically align in the correct place and with the correct formatting.
Note: With this method, VBA code cannot be recovered due to incompatibility between OpenOffice.org and Excel.
Full-proof method for corrupt Excel file repair
If you find the above methods confusing, or you wish to perform Excel file repair without having to face any data and formula loss, or you cannot achieve the desired results with any of these methods, stop wasting any more time with methods that will only frustrate you more. Instead, download the sure-shot solution for dealing with severe Excel corruption –Stellar Repair for Excel and relax!
Stellar Repair for Excel is the best choice for repairing corrupt or damaged Excel (.XLS/.XLSX) files and restoring everything to a new blank Excel file. This competent software can skillfully repair single as well as multiple XLS/XLSX files while preserving worksheet properties and cell formatting. If you have this product by your side, you don’t need to worry about Excel corruption errors ever again.
To Conclude
Instead of giving up on corrupted Excel sheets, try repairing them with the simple tricks we’ve described. And if they don’t work, keep calm and turn to Stellar Repair for Excel.
How to Fix “Errors were detected while saving Excel” Error?
When trying to save the Excel file, you might face unexpected errors. The “Errors were detected while saving Excel” is one such error. It can also occur when using VBA in Excel. The complete error message appears as:
**“Errors were detected while saving [file name]. Microsoft Excel may be able to save the file by removing or repairing some features. To make the repairs in a new file, click Continue. To cancel saving the file, click Cancel.”
**
The error can occur if the features (Pivot tables, charts, macros) used in the Excel file get corrupted . However, there could be several other reasons behind the occurrence of the error. Let’s discuss them.
What Causes the “Errors were detected while saving Excel” Error?
There are various reasons why you encounter this error. Here are some of them:
- Incompatible pivot table in the Excel file
- Large or uncompressed images in the Excel file
- File-sharing properties are not allowing file saving
- Excel file is corrupted
- Large-sized Excel file
- File version incompatibility
- VBA code is corrupted
Ways to Fix the “Errors were detected while saving Excel” Error
You’re not able to save the Excel file if there is no storage space on your hard drive. So, first check if your hard drive has sufficient storage space to save the file. If this is not the case, then it might happen that your antivirus program is interrupting the saving process. To check this, temporarily disable your antivirus program and then try to save the file. If still your Excel is throwing the “Errors were detected while saving Excel” error, then follow the below given methods to fix the error:
Method 1: Open the Excel in Safe Mode and Disable the Add-ins
When you open Excel in safe mode, it opens without the third-party add-ins. This helps in finding out if any add-ins are causing the error.
Here’s how to open the Excel in safe mode:
Open the Run window by pressing Windows key + R.
Type excel /safe in the Run window.
?
Next, click on OK.
It will open Excel in safe mode.
Now, try to open and save the affected file.
If you are able to save the file without any issue, then this means that the error has occurred due to third-party add-ins or settings. You can try disabling the add-ins to fix the issue. To do this, follow these steps:
- First, open Excel.
- Then, go to the File tab and click Options.
- In Excel Options, click on the Add-ins
- Under the Manage section, select Excel Add-ins and then click on the Go
In the Add-ins dialog box, unselect the add-ins under the Add-ins available option and click OK.
Note: Disabling add-ins does not remove them from the system. To remove them permanently, you need to uninstall them.
Method 2: Check the Excel File Name
Some users have observed this error when saving the Excel file with an invalid name. You can check the file name and ensure that it should not contain more than 218 characters. If the name exceeds the required limit, then try shortening the file name or move the file to a folder with a short path name.
Method 3: Copy the Data from the Affected File to a New File
If you are not able to save the Excel document, then try copying the data from the affected file to a new Excel file. Then, save the new file with a different name. This helps in resolving the issue.
Method 4: Check and Provide File Permissions
You may experience the “Errors were detected while saving Excel” issue when you do not have desired permissions to modify the folder in which your Excel file is located. To modify the folder, you should have read, write, and create permissions. You can check and provide the desired permissions using the below steps:
- Navigate to the Windows Program Files and then find the desired folder (where the Excel file is saved).
- Right-click on the folder and then choose Properties.
- Select the Security tab and then click
- Click on Change Permissions in the Advanced Settings
- Click Administrators and then click Edit.
- Now set the Apply to drop-down button to This Folder, Subfolder, and Files.
- Click on the Full Control field and then click Apply > OK.
Method 5: Check Pivot Tables in Excel Sheet
You can review Pivot tables to see if they are causing the “Errors were detected while saving Excel” error. To do so, follow the below steps:
Click Power Pivot > Manage.
Check the tabs in the Power Pivot
Check if all the formulas used in the table are correct. Sometimes, even a small typo can create an issue in Excel.
Method 6: Repair Your Excel File
The “Errors were detected while saving Excel” issue can also occur if the Excel file is corrupted. In such a case, you can take the help of the built-in utility in Excel – Open and Repair to repair your Excel file. Here’s how to use the tool:
- In Excel, click the File tab and then click Open.
- Click Browse to select the desired file.
- The Open dialog box is displayed. Click on the corrupted file.
- Click on the arrow next to the Open button and then click Open and Repair.
- Click on the Repair
After repair, a message will appear (as shown in the below figure).
Click Close.
However, sometimes, the Open and Repair utility fails to fix the file if it is severely corrupted or large-sized. In such a case, you can take the help of a third-party Excel repair software, such as Stellar Repair for Excel. The tool performs a comprehensive scan of the corrupted Excel file to fix the issues and recover all the items from the file without changing the original formatting. It can recover pivot tables, charts, images, engineering formulas, etc. The tool is compatible with Windows 11/10/8.1/8/7. You can download the free trial version of the tool to evaluate its functionality.
Closure
Many Excel users reported facing the situation when they are saving the Excel file. You can check the file’s compatibility to fix the “Errors were detected while saving Excel” issue. If you are getting this error in a Macro-enabled file then you can try deleting the VBA project from a document to resolve the issue. However, deleting the entire VBA code cannot be a better solution as it can lead a data loss in the Project you are working on. In the above article, you have learned the reasons behind the issue and discovered how to fix the error. Follow the methods and if none of them works then try using Stellar Repair for Excel. It is an advanced tool that can quickly repair corruption in Excel worksheets at any level. It lets you restore the corrupted components from the corrupted file without removing the existing data.
Also read:
- How to recover deleted photos from Android Gallery after format on Xiaomi Redmi K70
- How to recover deleted contacts from Gionee F3 Pro.
- How to play MP4 files on Moto G34 5G?
- How to recover deleted photos from Android Gallery without backup on Honor X8b
- How to recover deleted photos from Nord 3 5G.
- How to Retrieve deleted photos on A1 5G
- How to Restore Deleted 12+ 5G Contacts An Easy Method Explained.
- How to restore wiped messages on HTC U23
- How to Restore Deleted Huawei Nova Y91 Contacts An Easy Method Explained.
- How To Restore Missing Messages Files from Nokia 150 (2023)
- How to Repair Broken video files of Vivo Y27 4G on Windows??
- 4 Ways to Transfer Music from Asus ROG Phone 7 Ultimate to iPhone | Dr.fone
- How to retrieve erased call logs from Motorola Moto G14?
- How to Restore Deleted Nubia Z50S Pro Pictures An Easy Method Explained.
- How To Recover Lost Data on iPhone 15 Pro Max? | Dr.fone
- How to Recover iPhone 14 Pro Max Data From iOS iTunes Backup? | Dr.fone
- How to retrieve lost files from Motorola Moto G34 5G?
- How to Set up iPhone XS Max Face ID?
- How to recover data from dead iPhone SE | Stellar
- How to Restore Deleted Asus ROG Phone 7 Pictures An Easy Method Explained.
- How To Repair iPhone SE (2022) System? | Dr.fone
- How To Repair iPhone 12 Pro iOS System Issues? | Dr.fone
- How to Restore Deleted C67 5G Pictures An Easy Method Explained.
- How to recover old music from your G2
- How to retrieve erased videos from Xiaomi 14 Ultra
- How to Rescue Lost Videos from Y28 5G
- How To Restore Missing Messages Files from Tecno Camon 20 Premier 5G
- How to restore wiped music on Infinix Note 30i
- How To Restore Missing Pictures Files from Tecno Spark 20 Pro.
- How to Restore Deleted Nokia C12 Pro Contacts An Easy Method Explained.
- How to recover deleted photos from Android Gallery after format on 100
- How to restore wiped call history on Nokia C12?
- 5 Easy Ways to Copy Contacts from Nubia Red Magic 8S Pro+ to iPhone 14 and 15 | Dr.fone
- How to Retrieve Deleted Calendar Events iPhone? | Stellar
- How to restore wiped videos on Realme GT 5
- 4 Ways to Transfer Music from Nubia Red Magic 9 Pro to iPhone | Dr.fone
- How to Retrieve Deleted Calendar Events iPhone 13? | Stellar
- How to retrieve lost files from Tecno Spark 10 5G?
- How to Rescue Lost Pictures from Itel A60s?
- How to find lost iPhone X Backup files on Windows PC? | Stellar
- How To Transfer Data From iPhone 13 Pro To Others ios devices? | Dr.fone
- IMovie Review – Is It The Best Video Editor for Mac Users
- In 2024, How to Stream Apple iPhone 13 Pro Video to Computer? | Dr.fone
- Updated Templates Take Your Music Video From Drab to Fab and Add some Spice to the Catchy Song. Here Are some Templates You Could Use to Make Your Music Video Popular
- How To Transfer WhatsApp From iPhone 11 Pro Max to other iPhone 14 Pro Max devices? | Dr.fone
- In 2024, Ultimate Guide to Catch the Regional-Located Pokemon For Apple iPhone 8 Plus | Dr.fone
- Android Safe Mode - How to Turn off Safe Mode on Infinix Hot 40? | Dr.fone
- In 2024, Here are Some Pro Tips for Pokemon Go PvP Battles On Xiaomi 13 Ultra | Dr.fone
- How to Transfer Data from Apple iPhone 14 to ZTE Phones | Dr.fone
- In 2024, Ultimate Guide from Xiaomi Redmi 13C 5G FRP Bypass
- The 10 Best Tools to Bypass iCloud Activation Lock From Apple iPhone 13 mini You Should Try Out
- Complete guide for recovering messages files on Infinix Note 30
- Video Enhancement Software Boost Clarity and Detail Instantly
- How to Change Your Realme GT 5 Location on life360 Without Anyone Knowing? | Dr.fone
- How To Activate and Use Life360 Ghost Mode On Poco X6 | Dr.fone
- In 2024, How To Unlock iPhone 7 Plus Without Passcode? 4 Easy Methods | Dr.fone
- 7 Solutions to Fix Chrome Crashes or Wont Open on Vivo X Fold 2 | Dr.fone
- Complete guide for recovering video files on Vivo X100 Pro
- 3uTools Virtual Location Not Working On Vivo V29e? Fix Now | Dr.fone
- Best 5 Solutions on How to Add Emojis to iPhone for 2024
- In 2024, Is GSM Flasher ADB Legit? Full Review To Bypass Your Oppo A1x 5GFRP Lock
- In 2024, Unlock Your Device iCloud DNS Bypass Explained and Tested, Plus Easy Alternatives On Apple iPhone XS Max
- Is GSM Flasher ADB Legit? Full Review To Bypass Your Motorola Moto G04 Phone FRP Lock
- Updated In 2024, IMovie on Windows? Try These Top Alternative Video Editors Instead
- App Wont Open on Your Samsung Galaxy F15 5G? Here Are All Fixes | Dr.fone
- In 2024, Latest way to get Shiny Meltan Box in Pokémon Go Mystery Box On Asus ROG Phone 8 Pro | Dr.fone
- How to Fix It Vivo S17t Wont Turn On | Dr.fone
- The Updated Method to Bypass Oppo Reno 10 5G FRP
- Title: How to Fix the
- Author: Nova
- Created at : 2024-04-30 01:45:10
- Updated at : 2024-05-01 01:45:10
- Link: https://blog-min.techidaily.com/how-to-fix-the-value-error-in-excel-2003-stellar-by-stellar-guide/
- License: This work is licensed under CC BY-NC-SA 4.0.