Can't find project or library

anasttin1

New Member
Joined
Jul 20, 2017
Messages
8
Hi,

I have an Excel 2016 file that periodically has a problem.

On loading, it will say "can't find project or library" and I can't view the macros within it or check References in VBA (selecting references has no effect).

To fix it, I have to copy it to another computer with Excel, open and save it. Then it works again on the original computer.

I'm concerned that this fix will stop working at some point, beside it being annoying to move to and from another computer every other day.

Can anyone assist?

Thanks so much in advance.

:)
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,524
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
when you look at the vba on the machine that works, what version of excel, and what are the available references

when you open it on the offending machine and compile it, do the same refernces appear
 

anasttin1

New Member
Joined
Jul 20, 2017
Messages
8
Thanks for your reply mole999.

The machine that works is Excel 2010 but I think it also worked on a different Excel 2016 as well.

After fixing the file, I look at references on both the 2010 and 2016 and they look identical. Many libraries available in each and the same ones ticked in both.

I just tried compiling the vba and then looking at the references but it looked no different to the pre-compile state.

What are you thinking might be going on?

Thanks again.
 

Watch MrExcel Video

Forum statistics

Threads
1,129,296
Messages
5,635,367
Members
416,856
Latest member
silentir

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
Top