Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a bunch of Excel files that I have to convert from 2003 to 2010 format.

About five of them are written as Add-in (i.e. the isAddin attribute of the workbook is set to 'True')

Some of them has a dependency on others. e.g. DBUtils, responsible for retrieval of data from database server, is an addin used by the other four addins. So in Excel 2003, you will see DBUtils appear as an Addin in other xls files.

As a first step of conversion, I have individually converted the xls into xlam format.

Now I am attempting to update the addin's reference such that they will point to the new xlam files instead of 2003 xls files.

It is at this point I got the "Can't add a reference to the specified file"

enter image description here

How can I add a reference in Excel 2010?

share|improve this question

1 Answer 1

an add-in is not a reference in Excel 2010.

add-ins are added using the File -> Options -> Add-Ins
references tend to be OCXs, DLLs, and such

share|improve this answer
    
This couldn't be more wrong... –  RubberDuck Dec 3 at 14:18

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.