Change to addin location (v1.2.0) Featured

  • Bookmark and Share

A spate of Excel crashes in the office was recently brought to my attention. While not all of the crashes were attributed to the use of my addin, it did seem as though the chances of crashing were increased when my addin was present. This seemed to be related to the way the addin was loading; a typical Excel addin is loaded as a fully fledged addin (see this article for more on Excel addins) while I was using a more user friendly option, the XLSTARTUP folder.

In an effort to make installing and updating the addin easier for non-technical users, I have to date based my addin's installation on the use of Excel's XLSTARTUP folder.  This meant that it was relatively easy to save the file in this location, start up Excel, and all was good.  While a completely acceptable solution under normal conditions, loading from this location seems to have become a bit of a problem for my addin recently.

This has forced me to install my addin as a fully fledged addin going forward and will affect those users using the manual install option.  The download that includes the installer takes care of all of the housekeeping for the installation in the background, so (theoretically) running the installer should be a quick and painless exercise.  If you make use of the textamount function, please read the important note at the end of this article.

For users that prefer the manual option, please follow these steps to ensure that the addin is installed correctly going forward:

  1. Ensure that Excel is not open before installing or updating the addin.
  2. Delete the existing ieaaddin.xlam file located in the %appdata%\Microsoft\Excel\XLSTART folder.
  3. Download the latest version of the addin from the downloads page.
  4. Save the downloaded ieaaddin.xlam file to your downloads folder.
  5. Follow the instructions from this Microsoft article to install the addin properly.

Going forward, when updating manually, the downloaded file can be saved directly to the %appdata%\Microsoft\AddIns folder to overwrite the previous version.

Correct TextAmount formula Important information regarding the textamount function

When transitioning from v1.1.7 to v1.2.0, users that have used the textamount function may be prompted to update from a now non-existent addin file when opening files containing this function.  Cells containing the textamount function may also display a #NAME? message.  Ignore the prompt to update, then once the file has opened, go to cells where you have used textamount and select Correct TextAmount formula from the addin's ribbon.  This will update the formula to find the addin in its new location and will need to be repeated for each cell containing the textamount function.

If you experience any difficulties installing or updating the new version of the addin, please drop me a line using the helpdesk or the forum.

More in this category: « The grey is gone

Vulnerability Scanner

We use cookies to personalise content and to analyse our traffic. You consent to our cookies if you continue to use our website.