I find that XL2007 saved workbooks keep references to an add-in if it's
saved in XLS format or if it has a VB project and is saved in XLSM format.
In other words if the workbook is saved in the macro free XLSX format or is
saved in XLSM format but doesn't have a module (empty is okay) the reference
is lost.

--
Jim
"ma1achai" wrote in message
...
|I am making some changes for Excel 2007 compatibility to an old addin that
| has been around for several years. I am running into a problem where
Excel
| 2007 does not seem to be able to open References (in my case, to my addin)
| that were previously saved for a Workbook.
|
| For instance... create a blank workbook and a blank addin. Set a
reference
| within the workbook to that addin. To do this, in the IDE go to
| ToolsReferences and locate the addin and check it off. You will see in
the
| Workbook that a References folder is created with that reference in it.
If
| you save the workbook and reopen it, the reference is missing. Or at
least
| this is happening for me...
|
| Anyone else see this behavior and could give me advise on it?