'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix the 'Can't Find Project or Library' VBA Error in Excel
Question details
The user needs to fix a compilation error that stops an Excel macro from running due to unlocated project libraries or VBA references.
- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Running a VBA macro after transferring an Excel workbook to a different Windows device.
- Observed behavior
- Excel halts macro execution and displays a 'Can't find project or library' error message because the new environment lacks specific reference libraries.
Before modifying your VBA references, save a backup copy of your Excel workbook (.xlsm) to prevent any accidental loss of your macro code during the compilation process.
Clear Missing References in the Visual Basic Editor
This is the most common fix. Unchecking libraries that are marked as missing will resolve the error if your macro code does not actually require them.
When a workbook is moved between devices with different software versions, Excel may look for object libraries that do not exist on the new PC. Removing these broken links often restores macro functionality.
Open your affected workbook in Excel and press Alt + F11 on your keyboard to launch the Visual Basic Editor (VBE).
In the top menu bar of the VBE, click on Tools and select References from the dropdown menu.
Scroll through the list of Available References and locate any items that have the word 'MISSING:' prefixing their name. Clear the checkbox next to these items.
Click on Debug in the top menu and select Compile VBAProject. If no error messages appear, the compilation is successful.
Save your workbook, close the Visual Basic Editor, and run your macro again to confirm it executes without the error.
Manually Locate or Register the Required Library
Use this method if unchecking the missing reference causes a new compilation error, meaning your macro explicitly relies on that specific library.
Experience Seamless Spreadsheet Compatibility with WPS Office
Dealing with missing VBA libraries and complex macro errors when switching computers can disrupt your workflow. Try WPS Office as a free, lightweight alternative. It offers excellent format compatibility and a familiar interface, making it easy to migrate your workbooks and continue working without heavy resource usage or constant troubleshooting.
Frequently Asked Questions
Why does Excel show the 'Can't find project or library' error?
This error occurs when a macro references an external object library, application, or file that is not installed, has been moved, or is a different version on your current Windows device.
How do I know which VBA reference is causing the error?
Open the Visual Basic Editor (Alt + F11), click on 'Tools' in the top menu, and select 'References'. The problematic reference will clearly have the word 'MISSING:' prefixed to its name in the available list.
Will unchecking a missing reference break my macro?
If the macro does not actually use the specific objects or functions provided by that library, unchecking it will solve the error instantly without breaking anything. However, if the code relies on it, you will receive a new compilation error and must manually install or locate the library on your PC.
Does this error only happen when moving workbooks to another computer?
While it is most common when transferring files between devices with different software environments, it can also happen on the same PC if you uninstall a referenced program, move a system file, or upgrade your Office version.
