Hi Sameer,
This error can error due to various reasons like corrupt VBA code, file version incompatibility, pivot table issues, and even due to corruption in Excel files.
But not to worry, there are easy ways to fix it-
- Open Excel in Safe Mode and Disable Add-ins-
- Open the Run window by pressing Windows key + R.
- Type excel /safe in the Run window.
- click on OK.
- 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.
- Open and Repair-
- Open Excel and go to "File" > "Open."
- Navigate to the location of the problematic file.
- Instead of directly opening the file, select it and click the arrow next to the Open button.
- Choose "Open and Repair" from the dropdown menu.
- Excel will attempt to repair the file. If successful, save the repaired file with a different name.
This should work out for you. But if they don't, I'd say you refer to this article.
Best Regards.