[Fixed]: Can’t Find Project or Library Error in Excel (3 Solutions)

Get FREE Advanced Excel Exercises with Solutions!

While working with a large Microsoft Excel dataset, sometimes we see that our VBA macros show an error named can’t find project or library. It occurs because of the user’s Microsoft Access or Microsoft Excel program. Today, in this article, we’ll learn three quick and suitable solutions to fix the error named can’t find project or library in Excel effectively with appropriate illustrations.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


3 Suitable Ways to Solve Can’t Find Project or Library Error in Excel

Every program has a reference to an object or the type of library. If the program can not identify the reference or type of library, hence, the program can not use in VBA Macros, then it shows an error named “can’t find project or library”.

Use the Reference Command to Solve Can't Find Project or Library Error in Excel

Let’s assume we have an Excel worksheet that contains the information about several sales representatives of Armani Group. While using our worksheet in VBA Macros, then it shows an error named can’t find project or library because the program can not find the reference of that program or the type of library. Here’s an overview of the dataset for today’s task.

Use the Reference Command to Solve Can't Find Project or Library Error in Excel


1. Use the Reference Command to Solve Can’t Find Project or Library Error in Excel

We can easily solve the error named can’t find project or library by using the Reference command. This is the easiest and the most time-saving way also. Let’s follow the instructions below to learn!

Steps :

  • First of all, from your Developer tab, go to,

Developer → Visual Basic

Use the Reference Command to Solve Can't Find Project or Library Error in Excel

  • After clicking on the Visual Basic ribbon, a window named Microsoft Visual Basic for Applications – Can’t Find Project or Library will instantly appear in front of you. From that window, we will insert a Reference command from the Tools menu bar. To do that, go to,

Tools → Reference

Use the Reference Command to Solve Can't Find Project or Library Error in Excel

  • Hence, a dialog box named Reference – VBAProject pops up. From that dialog box, firstly, uncheck the Microsoft Office 16.0 Object Library option from the Available References drop-down box. Secondly, press the OK option.
  • After pressing the OK option, go back to your active worksheet and you will be able to save the Excel file.

excel can't find project or library

Read More: FIND Function Not Working in Excel (4 Reasons with Solutions)


2. Perform the Keyboard Shortcuts to Fix the Can’t Find Project or Library Error in Excel

Another easy way is to use the keyboard shortcuts to solve the error. Using the keyboard shortcuts, you will re-register or unregister the project or library file. Let’s follow the instructions below to learn!

Steps:

  • First, press Windows + R buttons simultaneously to re-register a library file.
  • Hence, a dialog box named Run will appear in front of you. From the dialog box, type exe in the Open box., and Press the OK button.

Perform the Keyboard Shortcuts to Fix the Can't Find Project or Library Error in Excel

  • Now, type the full path of the missing project or the library file. For example, regsvr32“c:\program files\common files\microsoft shared\dao\dao360.dll”.
  • If that can not be able to solve the error, you can simply unregister the library file, To do that, replace “exe” with “regsvr32 -u” and again paste the path of the project or the library which is given in the below screenshot.

Read More: [Solved!] CTRL+F Not Working in Excel (5 Fixes)


Similar Readings


3. Register a Library File to Solve the Can’t Find Project or Library Error in Excel

In several cases, the Microsft Access or Microsoft Excel shows a “can’t find project or library” error. We can solve the error by using the Command Prompt to register a project or library file. Let’s follow the instructions below to learn!

Steps:

  • First of all, If you are using the Windows 8 or later version, go to the search bar and type Command Prompt. Hence, press on the Run as administrator option. You can do that windows 7 or before from the start menu.

Register a Library File to Solve the Can't Find Project or Library Error in Excel

  • After that, a command window named Administrator: Command Prompt will appear in front of you. From that command window, type REGSVR32 “C:\Program Files\Blackbaud\The Raisers Edge 7\DLL\RE7Outlook.dll”.
  • Further, press ENTER on your keyboard, and you will be able to solve the error.


Things to Remember

👉 You can pop up Microsoft Visual Basic for Applications window by pressing Alt + F11 simultaneously.

👉 If a Developer tab is not visible in your ribbon, you can make it visible. To do that, go to,

File → Option → Customize Ribbon


Conclusion

I hope all of the suitable methods mentioned above to solve the Can’t Find Project Or Library Error will now provoke you to apply them in your Excel spreadsheets with more productivity. You are most welcome to feel free to comment if you have any questions or queries.


Related Articles

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.

Md. Abdur Rahim Rasel
Md. Abdur Rahim Rasel

MD. ABDUR RAHIM is a marine engineer proficient in Excel and passionate about programming with VBA. He views programming as an efficient means to save time while managing data, handling files, and engaging with the internet. His interests extend to Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning, reflecting his versatile skill set. He earned a B.Sc in Naval Architecture & Marine Engineering from BUET, and now he has become a content developer, creating technical content... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo