Fixed Freeze Panes not Working in Excel 2021 | Stellar
[Fixed]: Freeze Panes not Working in Excel
Summary: This blog discusses the “freeze panes not working” issue in Excel. It mentions the possible reasons behind the issue and offers workarounds and methods to fix it. If the issue is associated with corruption in the Excel file, you can use the specialized Excel repair tool mentioned in the blog to repair the affected file.
The freeze panes feature in Excel is used to freeze the row/column headings to keep them visible while scrolling the worksheet. It is a useful feature when you’re working on a large worksheet containing data that exceeds the rows and columns on the screen. Sometimes, you notice that the ‘Excel freeze panes feature is not working’. There could be numerous factors that can trigger this issue. Let’s know the reasons for the freeze pane not working issue in Excel and how to resolve this issue.
Why can’t I freeze panes in excel?
Several factors may contribute to the Excel freeze panes not working issue in Excel. A few of them are:
- The cell editing mode is enabled in the workbook in which you are trying to use the Freeze Panes feature.
- The Excel file is corrupted.
- The worksheet is protected.
- Advanced Options are disabled in Excel Settings.
- The Excel application is not up-to-date.
- You might be trying to lock rows in the middle of the worksheet.
- Your Excel workbook is not in normal file preview mode.
- Wrong/incorrect positioning of the frozen panes.
How to fix ‘Freeze Panes not Working’ in Excel?
The freeze panes option is available in the View bar. Sometimes, you’re unable to see the View option. It usually occurs if you are using the Excel Started version. Check and try to open the file in the advanced Excel version, which supports all the features. If you are using the advanced Excel version, then try the below workarounds to fix the freeze panes not working issue in Excel.
Workaround 1: Exit the Cell Editing Mode
If your Excel file is switched from normal file view mode to cell editing mode, you can encounter the freeze panes not working issue. In cell editing mode, certain features in Excel, such as the freeze panes, are temporarily disabled to prevent any conflicts. You can disable cell editing mode by pressing the ESC or Enter key. Now locate the View tab and check whether the freeze pane feature is working. If not, then try the next workaround.
Workaround 2: Change the Page Layout View
The Excel freeze panes not working issue can also occur if your workbook is opened in Page Layout view. The Page Layout view doesn’t support freeze panes. If you select page layout, the freeze panes option gets disabled.
To enable the freeze pane option, go to View and click the Page Break Preview tab.
Workaround 3: Check and Remove Options under the Data Tab
Sometimes, you can experience the “freeze panes not working” issue if Sorting, Data Filter, Group, and Subtotal options are enabled in Excel workbook. Such options, when enabled, can lead to unexpected problems with the freeze panes’ functionality. You can check and remove these features from your workbook. To do so, follow these steps:
- Open the Excel file in which you are getting the issue.
- Navigate to the Data tab.
- Check and remove the below features (if enabled):
- Sort
- Filter
- Group
- Subtotal
Workaround 4: Check and Unprotect Worksheet
The freeze panes feature may stop working if your worksheet is protected. You can try to disable the worksheet protection option. Here are the steps:
- In the Excel file, go to the Review tab.
- Click Unprotect Sheet.
After unprotecting the sheet, check whether the “freeze panes not working” issue is resolved. If not, follow the next workaround.
Workaround 5: Use Correct Cell Positioning
The freeze pane is not working issue in Excel can also occur when you use incorrect cell positioning to apply the freeze panes feature. Several users have reported facing this issue when trying to lock multiple rows with the wrong cell selection. So, use correct cell positioning to freeze the rows. For example, if you are trying to lock two rows in an Excel worksheet, then you need to click on 3rd row’s column.
What if the above Workarounds Fail to Fix the Freeze Panes not Working Issue?
If none of the above workarounds works, then there are chances that the workbook is damaged or corrupt. In such a case, you can try the below methods to repair the corrupt Excel workbook.
Run Open and Repair Utility
In case of corruption in the Excel file, you can use the Open and Repair tool in Excel to repair the file. To use this utility, follow these steps:
- In the Excel application, navigate to File and then click Open.
- Click Browse to select the workbook in which you are facing the issue.
- The Open dialog box is displayed. Click on the affected file.
- Click the arrow next to the Open option and then click Open and Repair.
- Click on the Repair option to recover as much data as possible.
- You can see a completion message once the repair process is complete. Click Close.
Use a Professional Excel Repair Tool
If the Open and Repair tool doesn’t work to resolve complex file-related issues and your Excel file is severely corrupted, you can opt for a reliable third-party Excel repair tool, such as Stellar Repair for Excel. This tool can help you repair the Excel file and recover all the data with complete integrity. You can try the software’s demo version to scan the affected file and preview the recoverable data. The software is compatible with all MS Excel versions and Windows operating systems, including Windows 11.
Closure
The “freeze panes not working” issue in Excel can occur due to several reasons, like protected worksheet, incompatible Excel version, and incorrect cell position. Try the workarounds shared in the blog to fix the issue. If the Excel file is corrupt, you can use Stellar Repair for Excel to fix the corruption issues in the file. This tool can quickly repair the Excel file and recover all the data from the file with 100% integrity.
[Error Solved] Excel file is not in recognizable format
Summary: Microsoft’s Excel is one of the most widely used spreadsheet tools, however, it isn’t entirely free of errors. There are in fact quite a large number of problems that can crop up in this user-friendly application which can put all work to halt. One such error occurs when Excel does not recognize the file format of .xls or .xlsx file and the error message says “Excel file is not in recognizable format” error. Let us explore this annoying error in detail.
Figure: Error message
From a small shop to the global industry giants, everyone relies on Microsoft Excel to complete their work. Quite a few businesses not only use Excel for their inventory tracking purposes but also to manage task lists and timesheets for their employees and project management charts. With high programming proficiency, one can create macros in excel which help in automating a lot of things. You can create quite a few variations, such as pie charts, bar charts, line graphs, area charts, and many more to showcase the data both in a tabular column as well as in a pictorial representation.
While Excel enjoys wild popularity, thanks to its powerful design and features, it doesn’t mean that Excel is all free of errors. There are actually repetition a few errors that one can encounter. One you might have come across is the error stating “Excel file is not in a recognizable format”.
What is this error all about?
The “Excel file in unrecognizable format error” occurs when the Excel file you are trying to load is corrupted. Microsoft has ensured that the workbook will be recoverable when the file is imported into excel but there are times when the automatic recovery does not happen. That’s where the challenge really lies. In such cases, getting to the root of the issue becomes necessary to be able to solve it.
Reasons behind the error
- One of the main reasons for the error is that the file must have got corrupted while being transferred from one machine to another.
- Another reason can be that the latest service pack might not be in use on your system.
- There could be MS Excel version change.
- Corruption of the file due to virus infection, extremely large databases, or multiple locks on the file at the same time can also trigger this error.
If you have ever faced this error, you do not need to panic. We have a couple of solutions listed for you when you face the Excel file in an unrecognizable format error.
How do you go about fixing this?
Solution 1: Use MOC.exe file to convert the workbook and then open it in Excel:
- Right-click on .XLS (you can use any .XLS files in your system).
- A new dialogue will appear. Here, click on “Choose another app” to select it.
Figure: choose another app
- You will now be presented with a number of applications which the OS thinks the file format will be compatible with.
- You do not have to choose any of the prepopulated apps from the list.
Figure: Look for another app
- Navigate using the Look for another app on this PC to the path “C:\Program Files\Microsoft Office\OfficeVersion”
- You will see a file name MOC.exe
- Choose that and complete your export.
- Try opening the workbook in Excel and the error should now be resolved.
Solution 2: Opening the file from within the Excel:
- Open a new Excel workbook.
- Press “Alt + F” or alternatively, go to the menu.
- Once you are in the menu, go to Options.
- You will be able to see a number of tabs on the left side of the options.
- Under the ‘Formulas’ tab, ensure that the calculation is in Manual mode – this setting is in the automatic mode, by default.
Figure: Manual option
- Click OK and save the changes to the workbook.
- Now, browse for the file which was corrupted.
- Click on the file and then select the option “Open and Repair”. You will find it in the drop down Menu.
Figure: Open and Repair
- Once the file has been imported, click on “Repair” to recover the data from the selected workbook.
Figure: Repair option
Solution 3: Use automated Excel repair software
If none of the above mentioned manual methods works to eliminate the ‘Excel file in unrecognizable format’ error, it means your Excel file has been severely corrupted and needs professional assistance. In such a scenario, quickly download reliable and competent software Stellar Repair for Excel. Backed by powerful scanning and repair algorithms, this product guarantees up to 100% Excel file repair regardless of the amount of damage in it.
- Download, install and launch Stellar Repair for Excel.
- Allow the software to scan the corrupted Excel file.
- All recoverable data will be listed in a tree-view list. You can select and preview any item from here.
- Select and recover individual or entire data from the file and save as a new Excel.
This method is currently the easiest and most convenient to resolve miscellaneous Excel errors.
Wrapping it up
Excel is one of the most powerful tools which can easily reduce your workload by more than 75% if used in a proper way. However, if you face complex errors like “Excel file is not in recognizable format”, you can use the methods mentioned above to get rid of it and resume your working in MS Excel. Remember, if the manual solutions don’t work, you can always rely on a proficient software like Stellar Repair for Excel to complete the job with finesse.
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 Repair Corrupt Pivot Table of MS Excel File?
Summary: If you are not able to perform any action on the Pivot Table of MS Excel file, it indicates Excel Pivot Table corruption. In such a case, you must repair the corrupt Pivot Table of MS Excel file by using an Excel repair software or manual troubleshooting steps discussed in this post.
MS Excel is equipped with several brilliant features and functions which make working with large volumes of data easy. In addition to helping users save data into well-organized cells and tables, the application helps users draw inferences from the data. Pivot Table is one such Excel feature that helps users extract the gist from a large number of rowed data. But often, the Pivot table may get corrupted and lead to unexpected errors or data loss.
Corrupt Pivot Tables can stop users from reopening previously saved Excel workbooks, raising the serious issue of data inaccessibility. Resolving such issues is an uphill task unless one gets to the actual root cause of the problem.
However, with Stellar Repair for Excel software, you can repair the corrupt Pivot table of MS Excel file while keeping the Excel file data, formatting, layout, etc. intact.
![Repair Corrupt Pivot Table of MS Excel File](https://cdn-cmlep.nitrocdn.com/DLSjJVyzoVcUgUSBlgyEUoGMDKLbWXQr/assets/images/optimized/rev-2658c43/www.stellarinfo.com/blog/wp-content/uploads/2020/07/1-2.jpg)Excel Pivot Tables & Associated Problems
Pivot Tables in Microsoft Excel are created by applying an operation such as sorting, averaging, or summing to the data in certain tables. The results of the operation are saved as summarized data in other tables. Typically, working on the grouping of saved data, Pivot Tables are used in data processing and are found in data visualization programs, such as spreadsheets or business intelligence software.
Put simply, Pivot Tables in Excel allow you to extract the significance or the gist from a large, detailed data set by allowing you to slice-and-dice data, sort-and-filter data, or arrange it in any way you want.
Frequently Encountered Problems with Pivot Tables in MS Excel
Take a look at the most frequently encountered Pivot Table issues:
- You add new data into a pivot table but it doesn’t show up when you refresh
- Pivot Table contains Blanks instead of Zeros for fields that have no source data
- Automatic field names assigned by the Pivot Table can be inappropriate
- It doesn’t directly show the percentage of total
- Grouping one pivot table affects another
- Your number of formatting gets lost
- Refreshing a pivot table messes up column widths
- Field headings make no sense and add clutter
While some of the above problems seem minute and can easily be resolved using a few tweaks, bigger issues like unexpected Pivot Table error messages that an Excel throws can be troublesome.
Pivot Table Errors & Their Reasons
Excel users who have built new Pivot Tables in Excel often report the following errors when trying to reopen a previously saved workbook:
We found a problem with some content in
Naturally, users are prompted to click on ‘Yes’. But when they do, they get another error message saying:
Removed Part: /xl/pivotCache/pivotCacheDefinition1.xml part with XML error
(PivotTable cache) Load error. Line 2, column 0
Removed Feature: PivotTable report from /xl/pivotTables/pivotTable1.xml part (PivotTable view)
Such errors are indicative of the fact that the data within the Pivot Table still exists, but the table itself isn’t functioning anymore.
There could be two primary reasons behind such behavior:
- You’ve created the Pivot Table in an older version of Excel but are trying to open-refresh-save it through a newer Excel version
- The Pivot Table itself is corrupted
How to Repair the Pivot Table Quickly?
To solve the errors associated with Pivot Tables, you need to repair them. But Microsoft doesn’t offer any inbuilt technique or option to repair Pivot Tables. Thus, to fix the issue, you either need some sort of workaround or an Excel file repair software .
Methods to Fix Corrupt Pivot Table in MS Excel
Though there aren’t many options to fix the Pivot Table, you can follow these workarounds to try and repair a corrupt Pivot Table of MS Excel. However, before following these steps, create a backup copy of your Excel file.
Method 1: Open MS Excel in Safe Mode
First, try opening the Excel file in safe mode and then check if you can access the Pivot Table. If you can, save all its contents to a new Pivot Table in the latest version of Excel so that this problem doesn’t arise anymore.
Method 2: Use Pivot Table Options
If, however, above method doesn’t work, follow the below-mentioned steps:
- Right-click on the Pivot Table and click on Pivot Table Options
- On the Display tab, clear the checkbox labeled “Show Properties in ToolTips”
- Save the file (.xls, .xlsx) with the new settings intact
Method 3: Make Changes to Pivot Table
If the above method or steps didn’t work,
- Try opening the Pivot Table Options window by right-clicking on the Pivot Table within your Excel file
- Select Pivot Table Options from the pop-up menu and make appropriate changes to the options given there
- Then check if the issues go away
Method 4: Check and Set Data Source
If the problem in the Pivot table is related to data refresh,
- Go to Analyze > Change Data Source
- Check if the data source is set properly
- Also, try reselecting the data source and check if the refresh option is working properly
If not, resorting to Stellar Repair for Excel software might be your only hope.
Excel Pivot Table Repair by Using Excel Repair Software
When corruption strikes an Excel Pivot Table and no manual trick work, Stellar Repair for Excel is the best solution. This easy-to-use Excel Repair software repairs even the most severely corrupted Excel (XLS/XLSX) files to restore all data, properties, formatting, and preferences. It enables users to extract their saved data into new blank Excel files.
If you have this utility by your side, you don’t need to think twice about any Excel error.
What customer says about the Excel Repair Software?
Conclusion
Excel Pivot Table corruption may occur due to any unexpected errors or reasons. This can lead to inaccurate observation in data analysis and also cause data loss if not fixed quickly. However, you can prevent data loss due to problems caused by Pivot Table corruption by keeping a backup of all your critical Excel files and fix the Pivot Table corruption by using proper tools, such as Excel file repair software, that can help you get over any Excel corruption and errors quickly.
[Fixed] Excel VBA Runtime Error 9: Subscript Out of Range
Summary: The runtime error 9 in Excel usually occurs when you use different objects in a code or the object you are trying to use is not defined. This post will discuss the reasons behind the Excel VBA error “Subscript out of Range” and the solutions to resolve the issue. It will also mention an Excel repair tool that can help fix the error if it occurs due to corruption in worksheet.
Many users have reported encountering the error “Subscript out of range” (runtime error 9) when using VBA code in Excel. The error often occurs when the object you are referring to in a code is not available, deleted, or not defined earlier. Sometimes, it occurs if you have declared an array in code but forgot to specify the DIM or ReDIM statement to define the length of array.
Causes of VBA Runtime Error 9: Subscript Out Of Range
The error ‘Subscript out of range’ in Excel can occur due to several reasons, such as:
- Object you are trying to use in the VBA code is not defined earlier or is deleted.
- Entered a wrong declaration syntax of the array.
- Wrong spelling of the variable name.
- Referenced a wrong array element.
- Entered incorrect name of the worksheet you are trying to refer.
- Worksheet you trying to call in the code is not available.
- Specified an invalid element.
- Not specified the number of elements in an array.
- Workbook in which you trying to use VBA is corrupted.
Methods to Fix Excel VBA Error ‘Subscript out of Range’
Following are some workarounds you can try to fix the runtime error 9 in Excel.
Method 1: Check the Name of Worksheet in the Code
Sometimes, Excel throws the runtime error 9: Subscript out of range if the name of the worksheet is not defined correctly in the code. For example – When trying to copy content from one Excel sheet (emp) to another sheet (emp2) via VBA code, you have mistakenly mentioned wrong name of the worksheet (see the below code).
1 | Private Sub CommandButton1_Click() |
When you run the above code, the Excel will throw the Subscript out of range error.
So, check the name of the worksheet and correct it. Here are the steps:
- Go to the Design tab in the Developer section.
- Double-click on the Command button.
- Check and modify the worksheet name (e.g. from “emp” to “emp2”).
- Now run the code.
- The content in ‘emp’ worksheet will be copied to ‘emp2’ (see below).
Method 2: Check the Range of the Array
The VBA error “Subscript out of range” also occurs if you have declared an array in a code but didn’t specify the number of elements. For example – If you have declared an array and forgot to declare the array variable with elements, you will get the error (see below):
To fix this, specify the array variable:
1 | Sub FillArray() |
Method 3: Change Macro Security Settings
The Runtime error 9: Subscript out of range can also occur if there is an issue with the macros or macros are disabled in the Macro Security Settings. In such a case, you can check and change the macro settings. Follow these steps:
- Open your Microsoft Excel.
- Navigate to File > Options > Trust Center.
- Under Trust Center, select Trust Center Settings.
- Click Macro Settings, select Enable all macros, and then click OK.
Method 4: Repair your Excel File
The name or format of the Excel file or name of the objects may get changed due to corruption in the file. When the objects are not identified in a VBA code, you may encounter the Subscript out of range error. You can use the Open and Repair utility in Excel to repair the corrupted file. To use this utility, follow these steps:
- In your MS Excel, click File > Open.
- Browse to the location where the affected file is stored.
- In the Open dialog box, select the corrupted workbook.
- In the Open dropdown, click on Open and Repair.
- You will see a prompt asking you to repair the file or extract data from it.
- Click on the Repair option to extract the data as much as possible. If Repair button fails, then click Extract button to recover data without formulas and values.
If the “Open and Repair” utility fails to repair the corrupted/damaged macro-enabled Excel file, then try an advanced Excel repair tool, such as Stellar Repair for Excel. It can easily repair severely corrupted Excel workbook and recover all the items, including macros, cell comments, table, charts, etc. with 100% integrity. The tool is compatible with all versions of Microsoft Excel.
Conclusion
You may experience the “Subscript out of range” error while using VBA in Excel. You can follow the workarounds discussed in this blog to fix the error. If the Excel file is corrupt, then you can use Stellar Repair for Excel to repair the file. It’s a powerful software that can help fix all the issues that occur due to corruption in the Excel file. It helps to recover all the data from the corrupt Excel files (.xls, .xlsx, .xltm, .xltx, and .xlsm) without changing the original formatting. The tool supports Excel 2021, 2019, 2016, and older versions.
Fixed “Cannot Insert Object” Error in Excel | Step-by-Step Guide
Summary: The error “cannot insert object” in MS Excel can prevent you from modifying objects in the worksheet. This blog will discuss the primary reasons behind this error and the possible solutions to fix it. You will also learn about a professional Excel repair software that can help fix the error if it has occurred due to corruption in Excel file.
Many users have reported encountering the “cannot insert object” error while adding/embedding objects into the Excel file. It usually occurs when using Object Linking and Embedding (OLE) to add content (PDF, Microsoft documents) from external applications to worksheet. The error can also occur when using ActiveX control in Excel. Below, we’ll explain why you cannot insert object into Excel sheet and how to troubleshoot the issue.
Why the “Cannot Insert Object” Error Occurs?
- Macro Settings can prevent the insertion of objects into a workbook.
- The Excel file in which you are trying to add an element is corrupted.
- The object (you are inserting into the workbook) is damaged.
- Object size limitations.
- System’s insufficient memory might prevent new objects’ addition.
- Incompatible Excel file format.
- Add-ins controls are disabled.
- Incompatible or faulty Add-ins.
- Issue with Security Settings.
Methods to Fix the “Cannot Insert Object” Error in Excel
You may encounter the “Cannot insert object” error when trying to add an element stored on a network. It can occur due to issues with the file link, such as incorrect file location. In such a case, you can check the link by selecting the link to file option from the Insert tab.
Sometimes, the error can occur if the file in which you are trying to insert the object is locked and password-protected. In this case, you can unprotect the Excel file . If the issue still persists, then you can follow the below methods.
Method 1: Check and Change Restricted Security Settings
Excel provides security settings to protect your workbook. Sometimes, these settings can prevent inserting objects in the file. You can change the security settings to allow Excel to insert objects. To do so, follow these steps:
- Open your Excel application.
- Locate the File and then click Options.
- In Excel Options, click Trust Center.
- Click Trust Center Settings.
- In the Trust Center Settings window, select Protected View from the left pane.
- Under Protected View, unselect the below three options:
- Enable Protected View for files originating from the internet.
- Enable Protected View for files located in potentially unsafe locations.
- Enable Protected View for Outlook attachments.
- Click OK.
- Once you’re done with this, click on Macro Settings in the Trust Center window.
- Under Macro Settings, make sure “Disable all macros without notification” is not selected. If it is selected, then unselect it. After that, click OK.
- Restart Excel to apply the changes.
Method 2: Uninstall Microsoft Office Updates
You can also encounter the “Cannot insert object” error in Excel after installing MS Office updates. It might be due to the issues with the installed updates. To fix this, you can uninstall the recently installed Office updates. To uninstall the Office updates, follow these steps:
- Go to the system’s Control Panel.
- Click Programs and then click Program and Features.
- Search for “View Installed Updates” and click on the desired Office updates.
- Right-click on it and then click Uninstall.
- Follow the uninstallation steps on the screen.
- Once the process is complete, restart the system.
Method 3: Check Memory Usage
The “Cannot insert object” issue can also occur if your system is low on memory. You can check and close unnecessary processes and applications running in the background to free up memory. To do so, follow these steps:
- Press CTRL + ALT + DEL on the keyboard and click Task Manager.
- Click on the Processes tab and search for any unnecessary processes.
- Right-click on the process and then select End Task.
- Restart Excel to see if the issue is fixed.
Method 4: Check Excel File Size
If your Excel file size exceeds the prescribed limit, it can also lead to the “Cannot insert Excel object” error. So, check the Excel file size. You can reduce the file size by removing unnecessary objects, such as formulas or images.
Method 5: Check and Change Excel ActiveX Settings
You can get the “Excel cannot insert object” error if your Excel file contains macros, controls, and other interactive buttons. It usually occurs if the ActiveX Controls option is disabled. You can check and change the ActiveX Settings to fix the issue. Here are the steps:
- Open your Excel application.
- Navigate to File and then click Options.
- In Excel Options, click the Trust Center tab.
- In the Trust Center Settings, click ActiveX Settings.
- Under ActiveX Settings, make sure the “Enable all controls without restrictions and without prompting” option is selected.
- If the option is not selected, then select it and click OK.
- Restart the Excel and check if the error is fixed or not.
Method 6: Repair the Excel Workbook
The “Cannot insert object” error can occur if the object you are trying to insert is corrupted or the file in which you are inserting the object is damaged. If the issue has occurred due to a corrupted Excel file, then you can repair the file using the Open and Repair utility in MS Excel. To use this Microsoft-inbuilt utility, follow these steps:
- In the Excel application, go to the File tab and then click Open.
- Click Browse to choose the affected 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 Repair.
- After repair, a message will appear (as shown in the below figure).
- Click Close.
If the Open and Repair utility fails to fix the issue, then try a professional Excel Repair software, like Stellar Repair for Excel. It is designed to repair severely corrupted Excel files. It can restore all the Excel file objects, such as tables, charts, formulas, etc. It helps fix all types of corruption related errors. The software is compatible with all versions of Excel.
Conclusion
You might encounter the “Cannot insert object” error when embedding or inserting objects in Excel. In this post, we have discussed the possible solutions to fix this error. We have also mentioned an Excel repair software that can help to easily repair the corrupted Excel file and recover all the data. You can download the Stellar Repair for Excel’s free demo version to preview the recoverable objects of the corrupted Excel file.
Solutions to Repair Corrupt Excel File
Summary: MS Excel can throw various errors due to corrupted Excel files. This blog discusses the error messages that indicate Excel file corruption and the methods to prevent data loss due to a corrupt file. It also discusses the reasons behind the corruption in Excel file and their solutions. It also mentions a “Stellar repair for Excel” tool that can help to repair the corrupt or damaged Excel file.
Is your Excel file corrupted? And you don’t have backup of your data? There is no need to worry. There are some simple solutions to repair Excel file 2019. But before heading towards the solutions, let’s discuss the possible reasons for Excel file corruption and how you can prevent losing your data.
Error Messages that Indicate Excel File Corruption
When an Excel file gets corrupted, different error messages appear. For example:
- “Excel found unreadable content in
. Do you want to recover the content of this workbook, click Yes.” - “Can’t find project and library.”
- “The workbook cannot be opened or repaired by Microsoft Excel because it is corrupted.”
- “Microsoft Excel has stopped working.”
Reasons Behind Excel File Corruption
The reasons for corruption in Excel file could be any of the following:
- Improper system shutdown
- Computer virus/malware attack/Hacker attack
- Outdated anti-virus definition
- Hardware failure
- Unintentional deletion of files
- Large Excel files
- Bad sectors on storage media
How to Avoid Data Loss Due to Excel File Corruption?
Excel users should follow the below precautionary measures to prevent data loss due to Excel file corruption:
1. Create an Automatic Backup Copy
When you create an Excel spreadsheet, it is advised to Save As your document, as follows:
- In Save As window, click Tools next to Save option.
- Select General Options from the drop-down menu.
- Then check the dialogue box Always create back up and click OK.
This will always create a backup of your Excel. If it’s deleted or corrupted at any time, it can be recovered.
2. Create Recovery File at Different Time Periods
Steps are as follows:
- Go to File and then click Excel Options.
- Click Save and then select the Save Auto Recover information every checkbox
- Add the required minutes and location. Ensure that Disable AutoRecover for this workbook only box is unchecked.
Methods to Repair Corrupted Excel 2019 File
Try using these 5 methods to restore your Excel file and recover data:
Method 1: ‘Open and Repair’ Excel Files
Excel automatically opens the corrupted file in Recovery Mode. If not, you can repair Excel file manually through the following steps:
- Click on the File and select Open.
- Go to the location where the corrupt workbook is stored. In the Open window, select the corrupt file.
- Click Open and then select Open and Repair.
- In the window that opens, click Repair.
If the Repair option doesn’t work, you can select Extract Data and try to extract the values and formulae safely from the corrupt file.
Method 2: Recover Data from Open Workbook
If you face issues while working in an Excel file, you can choose to return to the last saved version of the Excel file. For this:
- Click File. Then select Open.
- Double click on the name of the workbook (the one that is open in your Excel).
- Click Yes to reopen it.
- The workbook will now appear.
Please note that it will show the last saved version and changes made after that won’t be recovered.
Method 3: Set Calculation Option as Manual
You can also recover data from Excel workbooks that you’re unable to open. For this, you need to configure the calculation option as manual in Excel. You can do this through the following steps:
- Click on File. Select New and open a Blank workbook.
- From File, select Excel Options.
- From the Formulas category, under the section Calculation options, select Manual. Now click OK.
- Then click File, and select Open to open the corrupted or damaged Excel file.
Method 4: Recover Content by Using External Links
You can also recover specifically the content (leaving formulas/calculated values) from the workbook by using external references (to link Excel workbook). For this:
- Click on File, Select Open.
- Navigate to the folder that contains the corrupted workbook.
- Now, right-click on the file name of the corrupted workbook and click Copy.
- Click File button. Then, select New and create another blank workbook.
- In the first cell (A1), type =!A1 and press Enter.
- Select the corrupted workbook in the Update Values dialogue (if it appears). Then click OK.
- Select the relevant sheet in the Select Sheet dialogue (if it appears). Then click OK.
- Again, select the cell A1, go to Home and select Copy.
- Now select (start from the cell A1) an area equal to that of the data in the original workbook.
- Go to Home now and select Paste.
- Again, go to Home, and Copy the data (the same selection of cells).
- Go to Home, and then click on the arrow below Paste. Then click on Values.
By pasting values, you removed the links to the corrupted workbook and only the data is left behind.
Method 5: Excel Repair Software
If the above-mentioned methods do not help in repairing the corrupt Excel file, try an Excel repair software.
One of the most commonly used Excel repair tools is Stellar Repair for Excel. Its trial version is available for free download, which lets you scan and preview the repaired Excel files. Once you’ve ascertained the effectiveness of the software, you can save the file after activating the software.
Here’s the complete repairing process of the corrupt Excel file
Conclusion
This post shared the reasons behind Excel file corruption and precautionary measures to prevent data loss. It also outlined different methods to repair corrupt Excel file 2019. There are several in-built utilities in Microsoft Excel to repair corrupt workbooks and recover data from it. In case these methods didn’t work, you can use Stellar Repair for Excel – an easy-to-use DIY tool that can fix all Excel corruption errors and restore data with all original properties.
- Title: Fixed Freeze Panes not Working in Excel 2021 | Stellar
- Author: Nova
- Created at : 2024-07-17 17:16:40
- Updated at : 2024-07-18 17:16:40
- Link: https://phone-solutions.techidaily.com/fixed-freeze-panes-not-working-in-excel-2021-stellar-by-stellar-guide/
- License: This work is licensed under CC BY-NC-SA 4.0.