can't find project or library

ajm

Well-known Member
Joined
Feb 5, 2003
Messages
1,750
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?
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

ZVI

MrExcel MVP
Joined
Apr 9, 2008
Messages
3,658
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:

ZVI

MrExcel MVP
Joined
Apr 9, 2008
Messages
3,658
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:

Watch MrExcel Video

Forum statistics

Threads
1,099,378
Messages
5,468,265
Members
406,576
Latest member
mbehring

This Week's Hot Topics

Top