Updating the Add-On Version

This is sometimes required as the add-on window holds on to cached JavaScript code files for a long time, and does not seem to check if these files are out of date on a regular basis.

To clear cached files & get all files of the current version of any add-ons store Office add-on, follow these steps:

  1. Open the add-on you want to update

  2. Click anywhere within it’s window

  3. Click `Ctrl + Shift + R` to hard reload the files of the add-on, forcing fresh code retrieval 

As a note, certain file types do not get cached, meaning you can run into situations in which different files are from different versions of the add-on.

HTML files in particular do not get cached, which can lead to situations in which the page shows the user an up to date version number, but the code behind the page is actually from a different older version.

 

Clearing WebView2 cache for Office Add-ins

Symptoms:

When using auto-fill option for Spira URL/ User Name/ RSS Token cell, the mouse pointer moves to the last clicked excel cell

Solution:

1. Navigate to the cache folder (WEF) and delete all files within that WEF folder, to clear the cache.
Folder path:  localappdata%\microsoft\office\16.0\WEF

2. If the following folder exists, delete its contents, too:
%userprofile%\AppData\Local\Packages\Microsoft.Win32WebViewHost_cw5n1h2txyewy\AC\#!123\INetCache\

Attention: Before clearing the cache folders, make sure to close all Office apps as leaving them open might prevent files from being deleted.