title: VBA - “Can't find Project or Library” for custom .xla files that are correctly located
body: <p>We have a main <code>.xls</code> file that references several <code>.xla</code> files in the same folder. Most of the time, all the references open fine, but sometimes, seemingly at random, some users will starting getting <code>Can't find Project or Library.</code>.</p>
  
  <p>When looking at what is missing, it will be one of the <code>.xla</code> files; however, the path to the file it is looking for is exactly correct and the same files will work fine for others. We've found that if we rename the folder containing all the files, the problem generally goes away.  </p>
  
  <p>Due to users having shortcuts to the folder, we can't generally rename the folder though. The only way around it we have found is to create another <code>.xls</code> file that opens all the <code>.xla</code> files in the right order and then opens the main <code>.xls</code> file last. That works but it is confusing to users as to which version of the <code>.xls</code> file they should use.</p>
  
  <p>Anyone have any ideas what causes Excel to think something is missing when it is exactly where the reference is pointing or how to fix it (other than renaming the folder)?</p>