Updating AntView and MS Excel

Updating AntView and MS Excel

Please note that the installer automatically deletes all of the cache files mentioned below as of AntView version 1.0.88.

When you install the control via the installer out of date caching files for MS Excel should no longer be an issue.

When you update the AntView control to the latest version then MS Excel won't show you the updated functionality.

The reason for this is that Excel is caching the old interface in a few places in so called .exd files.

You only see the new functionality after you delete these cached files and re-register the ActiveX control.

You can find the .exd files the following locations:

The most commonly known one is here:

%TEMP%\VBE\AntViewAx2.exd

where %TEMP% is the local user temp folder, in other words, it usually is:

C:\Users\<user>\AppData\Local\Temp\VBE\AntViewAx2.exd

another copy might be in:

C:\Users\<user>\AppData\Local\Temp\Excel8.0\AntViewAx2.exd

Not only in the user temp folder, there's also:

C:\Users\<user>\Application Data\Microsoft\Forms\AntViewAx2.exd

which apparently maps to:

C:\Users\<user>\AppData\Roaming\Microsoft\Forms

Where <user> is the current Windows user, for example the first path on my system is:

C:\Users\Wil\AppData\Local\Temp\VBE\AntViewAx2.exd

Any & each of those .exd files must be removed in order to be able to update to the latest version of the AntView control.