Tip of the Day | Saturday 10 October 2026

This tool updates the references in your workbook's cell formulas that use the ASAP Utilities worksheet functions.

It is helpful when a workbook is opened on another computer where ASAP Utilities is installed in a different folder.
This can happen due to differences in Windows architecture (32-bit vs 64-bit) or how the add-in was installed (locally or on a network).
It also helps if you upgraded from the older .xla version of ASAP Utilities (used with Excel 2000 to 2007) to the current .xlam version, which works with Excel 2010 and later.

If formulas with ASAP Utilities functions show #NAME? errors, this tool can fix them by correcting the broken links to the add-in.

Starting this tool