Change default File Location of an Add-in

**ttd** · 09-27-2012, 11:55 AM

Hello all,

For Excel 2010...

I built an Add-in & Excel automatically saved the file in the below directory. This directory is not a shared drive with other employees at my firm & I am trying to move the Add-in file to a location that we all have access to. This way as I make changes to the add-in everyone will get the updates since we are all using the same Add-in. When I open the Add-ins menu in Excel then click browse & find the Add-in in the shared drive it asked if I would like to save a copy to the below directory. I say no since I do not want it saved there. It works but as soon as I close & reopen excel it prompts me that it cannot locate the Add-in since its not saved in the below directory. Is there a way to change the default directory to the shared drive where I want to house the add-in?

C:\Users\tbone\AppData\Roaming\Microsoft\AddIns

Thanks

**HaHoBe** · 09-27-2012, 12:11 PM

Hi, ttd,

my favourite tip would be to place it in a public folder and place a link to it in the XLSTART folder of Office.

Ciao,
Holger

**ttd** · 09-27-2012, 12:27 PM

When you say link is that a shortcut? I tried to place a shortcut in C:\Users\tbone\AppData\Roaming\Microsoft\AddIns and XLStart... the actual add-in file is saved in a public drive but it did not work.

**HaHoBe** · 09-27-2012, 12:34 PM

Hi, ttd,

you should find it in the path where the Office14 product is located.

Ciao,
Holger

**ttd** · 09-27-2012, 01:28 PM

how do I place a link to the add-in in the Office14 XLSTART folder? Thanks

**HaHoBe** · 09-27-2012, 02:03 PM

Hi, ttd,

maybe shortcut is the term to use: search for the file in the windwos explorer, copy, choose folder to place, choose create Shortcut there - a small file should be created which will load the addin on the normal start of Excel.

Ciao,
Holger