Can't find project or library error

Question

I am getting the following every now and then on my spreadsheets tat have Macros.  This is a new issue i'm having with excel and running the same Macros for the past two years.  How can I fix this without having to re save my files and re open  them on another machine, re save and then they will work fine for a while

Here is the event viewer error

- <Event xmlns="**http://schemas.microsoft.com/win/2004/08/events/event**">

- <System>

<Provider Name="Schannel" Guid="{1F678132-5938-4686-9FDC-C8FF68F15C85}" />

<EventID>36888</EventID>

<Version>0</Version>

<Level>2</Level>

<Task>0</Task>

<Opcode>0</Opcode>

<Keywords>0x8000000000000000</Keywords>

<TimeCreated SystemTime="2015-05-18T11:45:39.624938400Z" />

<EventRecordID>13285</EventRecordID>

<Correlation />

<Execution ProcessID="824" ThreadID="868" />

<Channel>System</Channel>

<Computer>Larry</Computer>

<Security UserID="S-1-5-18" />

</System>

- <EventData>

<Data Name="AlertDesc">10</Data>

<Data Name="ErrorState">10</Data>

</EventData>

</Event>

Answer 1

After you get the message, go into the VBE

In the project explorer on the left, make sure the problematic workbook is selected

Then go to Tools=>References in the menu (in the vbe).

You should see one or more references marked as "MISSING"

Uncheck that reference.   (if the workbook actually needs that reference, then  you will have to find it on your drive and recreate the reference to it).

Answer 2

After you get the message, go into the VBE

In the project explorer on the left, make sure the problematic workbook is selected

Then go to Tools=>References in the menu (in the vbe).

You should see one or more references marked as "MISSING"

Uncheck that reference.   (if the workbook actually needs that reference, then  you will have to find it on your drive and recreate the reference to it).  

Tom,

thanks for replying. I did some reading and deleted a file in m cache that was a .*exd file and it opened right up. I'll still check what you suggest.  Any clue what a *exd file does that would create this error?  I've had excel crash many times in the past and always when I delete this type file it runs fine until the next crash which may be 5 minutes orc5 weeks. Very random issue   I've had MS on my computer for hours /days and they had no clue. 

Thanks

Answer 3

An .exd file holds information about an activeX control.  If it is delete, then when needed it will be recreated.  If it exists and is corrupted or incompatible then it will cause problems until it is deleted.

A couple of months ago, Microsoft distributed an update that cause a lot of activeX controls not to work and the solution was to delete all the .exd files.  Perhaps this is related - perhaps not.  I don't recall it caused the message you describe, but if that fixed your problem then all is good. 

--

Regards,

Tom Ogilvy

Answer 4

After you get the message, go into the VBE

In the project explorer on the left, make sure the problematic workbook is selected

Then go to Tools=>References in the menu (in the vbe).

You should see one or more references marked as "MISSING"

Uncheck that reference.   (if the workbook actually needs that reference, then  you will have to find it on your drive and recreate the reference to it).  

How can I get the problematic file when it is not there.  When I get this error it will not open.  It crashes.  I deleted the exd file again but it still gives me the error

Answer 5

Is this what you are talking about? How do I correct it if it is?

Thanks