How To Fix Common Problems And Errors In Microsoft Excel
Microsoft Excel is still the most widely used spreadsheet and data processing app across all sectors of business and personal regimens. Excel, a powerful member of the Microsoft Office only rarely develops severe errors that may interfere with usability and performance.
Errors in Excel may arise for a number of reasons including macros, missing DLL files, corrupt workbooks, malware and infections.
Whatever your issue may be, we take a look at the most common problems and errors that you may encounter when using your Microsoft Excel app and likely solutions to solving them. Let’s get started.
1. Error – “Can’t find project or library”
The above error is one of the most common errors in Microsoft Excel and is usually caused by the inability of the program to access a reference to a type of library or an object. This is a because the reference item is not found and as such, the program sends an error message to notify that it can’t use the Visual basic or Micro-based functions or buttons required at that point in time. It can also arise from the fact that a library is being toggled off or on, resulting in a missing link between the program code and the library or due to a library mismatch when working with varying versions of libraries and applications.
There are a number of solutions that can be employed to fix the issue. Try the following steps to solve the issue
- Open the Excel workbook that is giving the error message
- Check that the sheet that has define buttons or functions is currently selected
- Press the ALT key along with the F11 key to pull up the Visual Basic editor in a new window
- Click the Tools menu and select References
- You should see a new dialogue box that will display a list of available references. You should find an object library or type that starts with the word Missing
- If there is a check mark on the missing object or library, uncheck this and click OK
- Exit the box and save your original Excel workbook
- Re-open the document to resume your work without errors
2. Fixing a corrupted Excel workbook manually
Excel workbook and spreadsheets may become corrupted for various reasons. If you have a corrupted workbook on your hands, there is a built-in tool to help you recover, repair or extract your data from your workbook. Here’s how to go about it:
- Navigate to the File tab and click open
- Locate the corrupted workbook by clicking browse
- Select the corrupted workbook
- In the dialogue box, find and click the arrow next to the open button and click Open and Repair
- If you want to recover as much data as you can from the corrupted workbook, click Repair
- Let the file repair, and re-open it to access your workbook
- If the repair process above failed, go back to iv and select Extract data to extract the formulas and values from the workbook
- If you’re working on an Excel sheet when the workbook becomes corrupted, it is possible to revert the workbook to the last saved version to recover the original worksheet. To do this, simply click the File tab and click open, double-click the workbook that you currently have open in Excel and select yes when prompted if you want to re-open the workbook
- This will automatically restore the workbook to last version that was saved before any changes made it to become corrupt
3. Error – “Error in loading DLL”
The “Error in loading DLL” issue is one of the most frustrating errors on Microsoft Excel and can occur for the same reasons as the first error we discussed above. This error similarly occurs due to the inability of the Excel app to find some libraries, DLL profiles and Macros. To solve this error:
- Open the affected workbook
- Click the Tools menu and navigate to the VB editor and select references
- See if you have any missing references and uncheck them
- Now, this is where it often gets tricky. Most people often deselect or uncheck the missing references only to notice that by the time they reopen the references, it has been re-checked. If you have the problem, here’s what to do:
- Close and re-open your workbook
- Disable macros and save your file
- Now, re-open without making any changes and then head to the references under the Tools and VB Editor
- Uncheck the missing references/Missing DLL
- Now, close the VB editor and save the document
- Re-open the document, re-enable your macros, re-save the document and continue your work. This should clear up the error.
4. Error – The program can’t start because Msvcr100.dll is missing from your computer
Try reinstalling the program to fix the problem.
This error occurs in Microsoft Excel as a result of a missing DLL file that is needed for the application to function properly. This DLL error may be caused by many things including malware, corrupt mso.dll files and wrongful deletion of the files.
To solve this issue, head over to Wikidll.com and download the relevant Msvcr100.dll file to your desktop. Most times, the DLL file will come in a .zip file and you will have to extract it to a folder on your desktop. Once you have the raw Mso.dll file, navigate to the C:\Windows\System32.
You can be first to leave a comment