The ASAP Utilities menu in Excel (English)
Fix Broken Links to ASAP Utilities Worksheet Functions
ASAP Utilities › Formulas › 13. Fix Broken Links to ASAP Utilities Worksheet FunctionsThis 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.
Screenshots
Starting this tool
- Click ASAP Utilities › Formulas › 13. Fix Broken Links to ASAP Utilities Worksheet Functions
- Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...
Additional keywords for this tool:
broken formula link, name error excel, fix #NAME? error, update worksheet function reference, fix asap utilities link, missing add-in function, update add-in path, asap utilities formula error, xla to xlam upgrade, fix formula links asap utilities, worksheet function not found, fix broken cell references, missing custom function excel, network install formula error
broken formula link, name error excel, fix #NAME? error, update worksheet function reference, fix asap utilities link, missing add-in function, update add-in path, asap utilities formula error, xla to xlam upgrade, fix formula links asap utilities, worksheet function not found, fix broken cell references, missing custom function excel, network install formula error
Choose your language preference below
English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語
| Insert Function from the ASAP Utilities Library... |
©1999-2025 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.