Share Excel Add-In In A Network Environment?

Colin Legg · #1 04-30-2012, 05:30 AM

Okay, so

First you need to save the add-in into the shared network folder.
Then I suggest you right click > properties and make the file read-only. This means that if you want to make an update to the add-in later on, it will not be locked by your colleagues.
Once the file is saved your colleagues need to open Excel > Office button > addins > Manage Excel-Addins > GO > Browse
In the pop-up window they then need to browse to the shared network folder and double click on the addin.
They will get a prompt asking them if they want to copy the add-in to their local AddIns folder. They should choose NO. If they choose YES then it would mean that future updates would be more difficult to give to them because their version of the add-in would be saved locally.
Once they click on OK your add-in and its macros should be available to them (it should be ticked in their add-in list).

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Microsoft Project 2010 taking up to 10mins to open file from network share.	BITS	Project	1	06-01-2011 09:37 AM
Office 2003 stops working looking for network share	Tim Donovan	Office	0	01-05-2011 11:32 AM
Access to an Office 2010 Excel file over network	lohith.korp	Office	2	09-27-2010 08:32 AM
How to synchronize Excel Sheet over Network	AmrMahmoud1982	Excel	1	09-24-2010 08:51 AM
Excel slow when connected with network and switching off server	viswaforu	Excel	0	07-06-2010 09:30 PM