EXCEL: Refering to an Add-In's spreadsheet cells

[SUnderwood]

Dear All,

Does anybody know if it is possible to refer to a range of cells within in loaded Excel Add-In?

I have created a range in my excel file called DBSeansJobInfo which equates to a range of cells on workbook JobData. Then saved the file as an Excel Add-In.

Opening another spreadsheet, I then install the Add-In using the tools menu and add a dropdown list to the sheet.

Then I create a range definition called "DBTestAddInLink" which equals "=[PDFInfo.xla]JobData!DBSeansJobInfo"

Then set
LinkedCell = "DBLink" and
ListFillRange ="DBTestAddInLink"

Strangely, although the range is 6 across and 1999 cells down, all I get is a list of 1999 cells in the farthest right hand colummn.

Any ideas on why this is happening and why I can't get the first 5 columns coming up would be greatly appreciated.

Sean