can't find project or library

ajm

Well-known Member
Joined
Feb 5, 2003
Messages
2,004
Office Version
  1. 365
Platform
  1. Windows
on trying to close one of my files, I get the "can't find project or library" message. there are no macros used in this file. I can then not open the References list from the Tools menu. I click on Tools and nothing happens. If i force close excel and then come back in using a different file, there are no problems and I can get to the References list. However, as soon as i reopen the file, and then try to close, same thing happens with regard to not be able to view the references.

Any ideas?
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
Hi,

Try to rename the copy of your file FileName.XLSB as FileName.XLSB.ZIP
Then open that renamed file in archiver like WinZip (or WinRar) and delete the item \xl\vbaProject.bin
After that rename back FileName.XLSB.ZIP to FileName.XLSB

Regards
 
Last edited:
Upvote 0
Cheers ZVI. where does that file come from?
 
Upvote 0
Cheers ZVI. where does that file come from?
If workbook saved with macros then VBAProject.bin is created, and PROJECT item in VBAProject.bin is used for saving structure and properties of the project.
Some combinations of those properties gets the behavior you have faced with.
May be file structure was damaged at saving in your case, not sure exactly why.
At least there were issues in some Insider Fast versions of Excel with file structures.
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,531
Messages
6,114,167
Members
448,554
Latest member
Gleisner2

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