Install the Workpapers NG add-in using a network share, where the IT administrator sets up a shared folder and end users add it as a trusted catalog in Excel.
Use this method for smaller organizations where centralized administrator deployment is not feasible, or when users need to access the add-in in an offline environment after the catalog is set up. This method requires 2 roles:
The IT administrator creates and maintains the network share and places the manifest file in the shared folder.
End users add the network share as a trusted add-in catalog in their Excel application.
IT Administrator steps:
Make sure you have the
manifest.xml
file for the add-in saved on your local device.
Create a folder on a server that's accessible to the intended users.
For example:
\\servername\shared_folder\addin_manifests
Grant at least
Read
permissions on the folder to all users who need to access the add-in.
Copy the
manifest.xml
file into the shared folder.
Provide the full UNC path of the shared folder to the end users who will install the add-in.
End-user steps
Open Microsoft Excel.
Select
File
, then
Options
.
In the
Excel Options
section, select
Trust Center
, then
Trust Center Settings
.
On the
Trust Center
screen, select
Trusted Add-in Catalogs
.
In the
Catalog URL
field, enter the full UNC path to the network share provided by your IT administrator.
Select
Add Catalog
.
Mark the
Show in Menu
checkbox for the newly added catalog.
Select
OK
to close the
Trust Center
screen, then select
OK
again to close the
Excel Options
screen.
Restart Excel for the new catalog to appear.
Select the
Home
tab, then
Add-ins
.
In the
Office Add-ins
screen, select
Shared Folder
.
The Workpapers NG add-in appears in the list.
Select
Add
.
Be aware of the following after installing the add-in:
Updates:
Unlike the Administrator Center method, manifest updates are not automatic. The IT administrator must replace the
manifest.xml
file on the network share with the new version. Users may need to clear their Office cache for manifest updates to take effect. In some cases, simply reopening the add-in after the manifest update is sufficient for web content updates.
Connectivity:
Users must have access to the network share to install the add-in from the catalog.
Security:
Set the network share permissions correctly to prevent unauthorized modifications to the manifest file.