Compile error: can't find project or library

[Sachin Narkhade]

I have installed LICSS 3.0 version and I am getting 'Compile error: can't find project or library', whenever I tried to activate the excel workbook. I am attaching screenshot of workbook. 

[Kevin Lawson]

Hi Sachin

 

This error arises when the Excel environment doesn't have all the necessary libraries. First thing to try is to use version 3.1 of LICSS available here: https://drive.google.com/folderview?id=0BxMZMNsy7g3oRkx0Rl9aQUtPSG8&usp=sharing (I removed dependencies in LICSS3.1 which weren't available with Office 2013). Workbooks created/activated with LICSS 3.0 should work equally well with LICSS 3.1 (unless you have used LICSS custom formulae in the workbook). If that doesn't solve the problem, then, after 'OK'ying' the error message, from the VBA editor window select Tools-References. On scrolling down the list you will probably find that one of the references is listed as missing. If so, please tell me which one and we can go from there....

 

Best wishes

 

Kevin

On Sunday, May 25, 2014 8:43:33 AM UTC+1, Sachin Narkhade wrote: