Can't find project or library error please help

axg275

Active Member
Joined
Oct 5, 2004
Messages
308
Hi,

My friend started to use my workbook and everytime he hits F9 to recalculate error comes up " can't find project or library" and it has OK and Help buttons.

I tried googling and searching here but can not find out exactly how to fix it. when I click OK VB references come up and in the list there are no items that have missing next to them. so I dont know when its missing. Also there are a few times that I can not uncheck because they are being used.

Is there anyway I can fix this?

Pleeeeese help us out :)

Thank you

axg275
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
Are you using the workbook on a common version of Excel eg both xl2007 or not? Do either of you have any add-ins installed which the other does not?
 
Upvote 0
we are using same excel verion. and we do have some add-ins that are not the same do addins matter?
 
Upvote 0
Sometimes add-ins can cause problems. I would ask your friend to temporarily uninstall his add-ins and see if it makes any difference to running the workbook.
 
Upvote 0
I had a similar issue... it was because some Add-ins were actually missing/unchecked... Not sure how they got unchecked (because I never did it manually), but once I re-checked Analysis Tool & Solution add-in my workbook opened up again.
 
Upvote 0

Forum statistics

Threads
1,215,063
Messages
6,122,935
Members
449,094
Latest member
teemeren

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top