Today I was not able to test my new developed Office Add-In for Microsoft Excel 2016 on my system and simultaneously on an IIS server.
I noticed the following behavior:
- Runing my Office Add-In from Visual Studio – everything went smooth
- Runing the same Add-In loaded from my App Store – didn’t work
Office tried to load the Visual Studio ‘version’ from of my Office Add-In instead the App Store and server-based one.
How to get around this issue?
Office saves the app manifests obtained from any app catalog in a sub folder of a GUID named directory here:
I was able to locate my app manifest XML in one of these sub folders.
Office did load the manifest pointing to my local IIS instead of the server version. The manifest stored in this folder pointed to local host.
To load my server based version of my app I deleted the folder containing the ‘local’ manifest. Restarting Office was the last step to load the new manifest from the server.