Close Window   
Free Ebook
Get Your Free Excel
Our Top 15 Excel Tutorials
Instant Access!
Subscribe for Free Excel tips & more!

Cant Find Project Or Library Error When Running An Office 2003-file On Office 2010

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More


My subject says it all basically. I have created a workbook at work using excel 2003 but when I try to work at it at home (in office 2010) i get the "Can't find project or library"-error. It seems that it's only my userforms that generate this error.

Any ideas to why?

Thank you all brilliant minds!

View Answers     

Similar Excel Tutorials

Remove Vlookup #N/A Error in Excel
How to remove the #N/A error from Vlookup and replace it with a friendly message or a blank cell. Fix the Vlookup ...
How to Get a Free Excel Trial
You can download Microsoft Office, including Microsoft Excel for a free trial period. This grants you full access t ...
Open Excel Workbook Using VBA Macros
Simple way to open an Excel workbook using VBA and macros. Syntax Workbooks.Open ("File Path") Replace file path w ...
Print Only Specific Parts of a Worksheet in Excel
In Excel you can select parts of a worksheet to print while ignoring all of the other data on the worksheet. This a ...

Helpful Excel Macros

Excel Macro to Save a Specific Worksheet as a New File
- This Excel Macro allows you to save a specific worksheet within the Excel Workbook to its own new file. You will be a
Delete a VBA Module From Excel
- Delete a VBA macro module from Excel with this macro. This macro allows you to fully remove a macro module from Excel.
Save the Current Worksheet as a New Excel Workbook File
- This Excel Macro will save the currently visible/active worksheet (the one that you see when you run the macro) to a
Display the Print Window in Excel
- This free Excel macro displays the print window or dialog box in Excel. This is the same window that would appear when
Delete All Chart Sheets in Excel - Only Chart Sheets are Deleted - Not Embedded Charts
- Delete all chart sheets and tabs in Excel using this macro. This will only delete the charts and graphs that are in the

Similar Topics

I have just upgraded to Office 2010 and suddenly one of the .xla files that I use will not load and gives the error "Can't find project or library". I have seen mentions on the web of checking Tools->References but References is greyed out. Any ideas/

We have a macro that exports the data from Project 2010 to an excel file. It works well when we use it on a Windows 7 or a Windows 8 machine, but with Office 2010 installed. But now when I am testing it on a Windows 8 Machine with Project 2010 standard but Office 2013, I am getting a Compile error of Cant find the project or Library.

The macro references Microsoft Excel 14.0 Object Library (under VBA menu - Tools - References ) on the machines that it works fine. But on the Windows 8/Office 2013 machine it references to Microsoft 15.0 Object Library. Is this what is causing the error?

Can someone please help me how to figure this error out? How do change the reference or fix the reference?

can anyone here adivse me on what to do. I have now finished my project and
it works exactly as i want it too. However, i have come across this very
large problem.
Introducing the book onto our server where everyone else uses excel 2000. I
created this book on excel 2003. So when someone else issues a macro they
immediately get an error saying Object not found.
i went into the Visual Basic Editor / References and looked for the office
library but it says:
MISSING.Office 11 object library.
Is there a way around this or have i just wasted my time on this book? Can i
copy over the office 11 object library, or save this book as an earlier
or, do i have to upgrade everyone to office 2003?

please advise.

Very Frustrated Nige

I have an Excel 2007 spreadsheet that works perfectly but will not work with Excel 2010. One of the lines of code that is now failing is -

ResultsWindow.PostTax.Value = Format(0, "$* #,##0")

All this is trying to do is to format a number in a field on a Userform but I get the message "Compile Error: Can't find the Project or Library". From what I have been able to find on the internet, this is a problem with MS SOAP v3 not being compatible with 64 bit systems. In the program references, Microsoft Office SOAP type library v3.0 is shown as missing.
Does anyone have a simple fix for this type of problem. Thanks.


I'm working on an automation that will connect ms excel and outlook.

A flexible code has to be written to work on both office 2007 & 2010 versions.

I'm getting a compile error "Can't find project or library" when i used a code taken from the below thread.

I've given the code below which i used. Kindly help to overcome this issue as this an urgent assignment to be completed.

Please Login or Register  to view this content.

The code given below was working in the environment: Windoes xp/ Excel 2007/ MS Office Project 2007. Recently I chnaged to Windows 7/ Office 2010/ MS Office Project 2007.

I am get the following error
Run time error '-21473179771 (800280 1d)'
Automation error. Library not registered.

I have marked 'bold', the location where I am getting the error. Would appreciate if you can give me a solution. Thanks

Please Login or Register  to view this content.

I'm a novice with VBA in Excel and I'm not sure how Object Libraries work. I have a workbook in MS Excel 2010. I have code written that will take one of the single sheets in the workbook and create a new mail message in Outlook with the sheet attached and ready for the user to enter an email address for sending. I discovered that to make this work, I had to reference the Microsoft Outlook 14.0 Object Library in the workbook. This code works perfect in MS Excel 2010. My problem is that some of my users run MS Office 2007. When they fire the code to send the email, they get a bug (Library not found). I can fix this by having them reference the Microsoft Office 12.0 Object Library that comes with MS Excel 2007 and it will work fine. I update this workbook and redistribute to my users all the time and evertime they update, they get the "Object not found" error because the version I send them doesn't have the proper 12.0 Object Library referenced. How can I redistribute my workbook WITH 12.0 Object Library referenced so that they don't have to go to VB and update the reference?

Basically, the macro I created for my worksheet works fine on my computer. However, when I posted this file to our internal system so that other coworkers could use the file. They got this "can't find project or library" error. The excel file works fine on computers in my department, but it only works for some people who work outside of my unit.

I looked this error up on the web and found that it is a fairly common error. So, I tried to solve the problem by comparing the References that my other coworkers had to the References that I had on my computer. It turns out that they get the same errors even though we both have the same References (OLE Automation, Microsoft Office 11.0 Library..) .

I want to stress that I have not unchecked any libraries because I'm assuming that since we have the same references, then unchecking those libraries will make no difference.

Is there any way to solve this problem? Please let me know. Thanks.

Hi all,

I've had a file that has been in use for many months without a problem but now all of a sudden I get a "Can't Find Project or Library" compile error in a userform.

The line that is triggering this is Ucase(application.username).

Has anyone of you expreienced something similar? I've searched everywhere for a reasonable explanation . I may have opened and watched the code from within Excel 2010. Could this have something to do with it?



this is my first post in this forum.. so please bear with my language..
I am running Windows 8 Pro (64bit) and Office 2010 SP1 (32bit) (both patched up to date) and have a Office 365 P1 subscription.

When I create a document from a SharePoint online document library,
the document opens the correct local app, i.e. Word 2010, allows me to edit,
but when I come to save the document back into SharePoint online, Word displays the following error:

Upload Failed. Your changes were saved but could not be uploaded because of an error. You may be able to upload this file using the server Web page.

It allows me to save the document locally and use SharePoint upload to manually upload the document, however this is not the method I am trying to use that should otherwise work from the client app.

I work with SharePoint in my professional career and I know that documents created in SharePoint should able to be saved directly back to the document library from where they were created from.

The Upload Center also displays an error for the document I have attempted to upload but simply states Upload Failed.

I have cleared the Document Cache, rerun the Desktop setup and reinstalled Office 2010 without success. The only thing I have not tried is using Windows 7, Office 2010 and Office 365.

Has anyone identified an answer to this issue?


I just built a new tower system to replace my older laptop (it's a real screamer BTW, so if anyone wants specs just PM me).

I'm now Running 64-Bit Windows & Office 2010, as well as 32-Bit Vista & Office 2003 in a VMWare Virtual Machine to support older apps.

I was working on a 2003 db in the Virtual Machine and shut it down (for some odd reason VMWare needs to be shut down every few hours or it just gets progressively slower), then opened it in 2010 to check something. When I reopened it in 2003 I got a "VBA Project Corrupted" error message that required a hard shut down to exit. I then got the same error in 2010.

I know that the 64-Bit versions require some additional VBA security protocols/checks, but has anyone else experienced the corruption error?

Fortunately I had a backup and lost very little work, but it's still a PITA, so if there's a way to program in a prevention I'm all over it.


I have a workbook that contains macros that allow export of data in Word Format. However the workbook was designed using Office 2010 and when tried with Office 2002 missing Reference to "Office 14 Word Object Library" is noted.

All other References though migrate ok.

I have added code to remove all References by GUID reference numbers on exit and reintroduce them on load. This works together with some late binding for some features not supported between 2010 to 2002.

I would rather not do this as I want to give the workbook to others to use and this requires "Trust access to VBA project object model" to be set.

This is my first post, so I hope explanation is clear.


Last time i did some excel vba using excel 2003, but after changing to 2007, my program can't work. The error says like this : Compile Error: Can't find project or library.
How could I solve this?
I've upload the file for reference

Thanks in advance!!!

Hello- I'm banging my head against the wall on this one. Searched this site, but can't find a solution.

When I try to open an .xls file in office 2010, I get the following error: 'file is in a different file format than its extension indicates'. It then opens in protected mode.

What is wrong. The file opens fine in 2003, but when I try to open in 2010, I get that error.

Any advice?


Setup: Office 2003 and 2010 - All versions are up to date and running in Win 7.

Hello all,

I really need to make this work, so hopefully someone can help me. I wrote the macro VBA code in Excel 2010 and its all working, however, when i transfer the file to Excel 2007 or older, it gives me a Compile error: cant find project or library and highlights (Format() function).

I read stuff in internet that there needs to be adjustments made at the other PC's, however i do not have access to them. Is it possible to maybe decrease the complexity or declare values differently so that it would work on the older software?

I am attaching the workbook here. If i missed out some information or you have any questions, please ask!

Hello everybody,

Is it possible to show a message box when a workbook is opnened in version 2010?
I would like to give users some instructions for an error that occurs when opening in 2010.

Some features I used aren't recognized in 2010 and gives the error:
"Compile Error: Can't find project or library"

This can be solved by following these instructions:
1. Open the database or application.
2. Open a module in Design view or press ALT+F11 to switch to the Visual Basic Editor.
3. On the Tools menu, click References.
4. Clear the check box for the type library or object library marked as "Missing:"

Even better still would be if these steps can be done utomatically

Hello Experts

I am back again with some problem that is recently i formatted my system and reload the Windows 8 with Office 2007

now my problem is when i run the code then i am getting the one error msg that is

Compile error

Can't find the project or Library

Please Login or Register  to view this content.

When i press the Ok button then it is select to the line is

uRows =

kindly suggest me with the above problem and suggest me how to check the missing Objects or Library in excel file

Thanking You in advance


I'm in a client office where the version of Office is 2010. At home I only have Office 2003 so I often save spreadsheets in 2003 format (.xls instead of .xlsx) so I can use them at home. When I do this it takes up to 10 seconds to save the file even if there are only a few cells occupied. Previously I've used computers with Office 2007 and found Excel 2007 would save in Excel 2003 format almost instantly.

Is there something wrong in my Office 2010 set up? If so, what I can do to Excel 2010 to make it save faster in the 2003 format?

Could it be that Microsoft has put this slow feature in deliberately to encourage all users of Office 2003 to upgrade, or am I just being paranoid?

I have an excel file where I copy ranges to a word document. I was initially writing this in excel 2003, but they've upgraded my machine to office 2010.

I didn't know it, but the word reference got updated to microsoft word 14 instead of 11. So I got the can't find project or lib error when running it again in 2003. I've tried to ensure this works in 03/10 as we have mixed machines.

It was easily fixed by unchecking the 14 ref and renabling 11 but is there a way in code or something to prevent this from happening? I don't think you can enable a reference via vba so maybe there's no way around it, but wanted to see if there's a solution I'm not aware of.

OK I found this:

so I think it may be possible but it's not working out:

I tried:

Please Login or Register  to view this content.

but getting the error: user-defined type not defined. Then I read to enable trust accsess to visual basic project in macro --> security but same thing.

Then I read enable ms visual basic for extensibility but that didn't work.

Is there some other means of doing this?

I have a program which was developed in Excel 2003. It has always worked fine on my web book using Excel 2007. All of a sudden, whenever I try to enter data anywhere in the file I get an error screen which says "Can't find Project or Library". I tried replacing the file thinking it night be corrupt, but I keep getting the same error message. I clicked on the help screen but I'm not sufficiently experienced with computers to even understand what help is talking about. Anyone have any suggestions?


One of my WB behaves very strange lately.

Upon opening, it presents a lot of "Compile Error: can't find Project or Library".

Hereunder is on of the UDFs I have in this WB and the compiler marks this TheDate = as the cause for the error.

I cannot click 'References...' (to check for: Missing) because it is grayed-out.

I didn't use any Option Explicit command and that file works fine when opened in Excel 2003 (in which it was originally created).

Any Ideas ?

Thanks, Elm


Function Quarter(CheckDate As Date)
    TheDate = CheckDate
    Quarter = DatePart("q", CheckDate)
End Function

I have an add-in I used in several earlier versions of excel. It is named


During previous upgrades, I copied the file to the directory containing add-ins--here on my current system:
"C:\Program Files (x86)\Microsoft Office\Office12\Library\!OPTIONS.XLA"

then "enabled" the add-in from the excel menus.

With excel 2007, I get an error message:
"opening the VBA project in this file requires a component that is not currently installed. This file will be opened without the VBA project. For more information, search Microsoft office online for vba converters."

This workbook has lost its VBA project, ActiveX controls and any other programmability-related features.

After I have installed the add-in, I get these error messages on excel startup. When I have unistalled the add-in, I get these messages upon openeing a spreadsheet that tries to use the add-in.

I have searched Microsoft extensively. The only vba converter I have located there is to convert excel 2007 vba to be usable by earlier versions.

Can I make my add-in work for 2007?

I have a spreadsheet with a set of macros. One of the macros used the Microsoft Calendar Control 11 to furnish a popup calendar. However, I have disable this by erasing the page code which referenced the control.

I have given a copy of the spreadsheet to a coworker. Everything worked fine until she got Office 2010, at which point the macros quit working with the error message "Unable to find project or library." Using the VBA References dialog box, I have traced this issue to the fact that the Office 2010 installation on her computer does not have the Calendar Control 11 file. I went into the References dialog & tried to uncheck Microsoft Calendar Control 11, but I get an error message telling me it can't be deleted because it's in use. I've looked through my other macros & can find no references to it. The help box on the error message says to remove the control from the form & then uncheck the box. There are no forms listed in the project window.

Can someone tell me how to find where this may be so I can delete it? While we could just install the control file on her computer, I'd really prefer to clean up the spreadsheet so I don't keep running into this every time I provide a copy to someone.

Any help appreciated.

---GJ Case

I am writing Excel automation using Visual basic 6.

The application is supposed to read the excel file created by the
Office 2003 version. I also have Office 2003 on my machine so I set my
reference to "Microsoft Excel 11.0 Object Library"

Now when I try to run the program on the computer that doesn't have
Office 2003 but has Office 2000, it crashed.

Can you let me know how to handle this problem.

I do have the error handling section to display the error but it seems
that the program try to execute but got Error "An exception "Unhandled
Win 32 Exception" has occured in Program.exe"

I would like to check if the excel on the machine is not version 2003
and just abort the program without crashing.

Can anyone help with the sample of source code to determine the version
of Excel in the computer?


Hi friends,

I am getting the following error each time when i close the workbook or I use the addin.

"object library invalid or contains references to object definitions that could not be found".

I have used the same addin many times. Yesterday I upgraded Microsoft Office to 2007 and since then I am getting this error. I have again installed Microsoft office 2003 but still i am not getting rid of the error.

In VBA --> Tool --> Reference there are no references that are missing..

Please help.