NET Framework version, the debugger uses the debugging engine of . To help the debugger, you can create (or modify) the .config file(s) for the Office application(s) installed on your PC.You do this using the Host Configuration command of the COM add-in module; create an empty COM add-in project, if required. NET-based Office extensions loaded by the Office application.An external link formula shows the full path to the source if that workbook is closed, otherwise it shows only the workbook name in the path.For more information, see the MS article ‘Create an external reference (link) to a cell range in another workbook’ You can link to cell addresses or names; obviously named ranges are safer because addresses can be affected by insertions or deletions in the source worksheet.
When processing those actions, the host application generates a number of events (available for you through the corresponding object models). We suggest checking the environments in which your would-be add-in will work. I am hoping to retire from my full time job through writing so I can buy a cabin in the South Carolina mountains and become a career author.This problem occurs when you debug an add-in project targeting to . The reason is the debugger, which doesn't know what . To find out that info, the debugger checks the .config file of the executable, which is the host application in your case.In sheet 2 I have some VLOOKUPs that retrieves the new data from sheet 1.I sent this worksheet to my brother, who has Excel 2007.