Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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 '14 at 14:18

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .