When using MS Excel document or MS Access that assimilate functions or buttons which need VBA (Visual Basic Applications) for the Macros to perform some assigned task, the user may get a compilation error “Can’t find project or library”.
For different situations some solutions to rectify the problem or to repair corrupted Excel file are always there. Like finding out the missing library or the cause of mismatch if it exists. The library is then added or alternatively the code may be rechecked to link to the appropriate library.
How can it be done?
Following the steps:
Step 1. Open the MS Excel file, giving an error message.
Step 2. Ensure that the sheet that has defined functions or buttons is selected.
Step 3. Press “ALT and F11 keys”, for VB Editor in a new window (as below).
Step 4. Click on Tools menu and then select References from pulled down menu, as shown
Step 5. Following dialog box will display ‘Missing object library or type’ is indicated, as shown below
Step 6. As in above display if check mark exists with missing library, uncheck it and click OK
Step 7. Exit and save the original Excel file.
Now check to ensure respective functions are working properly.
Third-party Excel file repair software are there to resolve all such matters quickly and accurately. One of the Best Excel file Repair software, to repair and recover damaged/ corrupt Excel files is described below.
This Excel file repair software is available for single as well as multiple systems. The file repairing tool supports all versions of windows and supports Excel 2011 for Mac. This permits repair corrupted Excel file (.XLS and .XLSX), and restore all the data from corrupt to a new Excel file.
Step 1 Select corrupt Excel file from drive and search.
Step 2 Chooes one or all corrupt Excel file start to repairing process.
Step 3 Preview the repaired Excel file.
Step 4 Select a preferred location to save repaired Excel file.
In addition to Excel Repair Tool or Excel file repair software, a few tips may be helpful for quick fixes (to recover or repair corrupted Excel file).
Excel XLSX files are wide used in business and it is important to find a way to find them back once they are deleted. This guide is for you to perform XLSX recovery in 3 steps. ...
The error "Cannot access read-only file"or "file-name"" can be solved by the best Excel file repair tool.Read on to find our how easy it will be. ...
This page offer the best solution to repair corrupt and damaged word files in Microsoft Word 2016,and safe recovery of MS Word files. ...