I have an add-in I have written and provided to a number of people. We currently use Excel 2003, but are migrating to Excel 2007 or 2010. The add-in works well as long as you are the creator of the spreadsheet that used the add-in. When I or someone else shares the spreadsheet with someone else it always asks for the user to update links. The add-in is always in the list. Everyone always has to navigate to the plugin directory and select the add-in. The add-in is stored in the directory 'C:\Documents and Settings\<username>\Application Data\Microsoft\AddIns' where the username changes for each individual.
Is there a way to for excel to automatically update the add-in when sharing the spreadsheet or is there a common location which is better to install excel add-ins?
Is there a way to for excel to automatically update the add-in when sharing the spreadsheet or is there a common location which is better to install excel add-ins?
