logo ASAP Utilities

Answered Questions (FAQ)

If you have a question or experience a problem with ASAP Utilities then please verify if there is already an answer to your question or solution for you problem in our list of frequently answered questions.

Priority support for clients

If you can't find the answer on our website then please contact us.

Version history

A history of the various updates and improvements throughout the years

How it makes YOU rock in Excel

These short tutorials show you how to benefit from the tools in ASAP Utilities and are guaranteed to save you time and speed up your work in Excel.

User Guide

The ASAP Utilities User Guide is a practical manual that will show you how to get the best out of our excel add-in

Uninstall

How to (temporary) uninstall ASAP Utilities.

Bug report

If you have found a bug first make sure you are using the most recent version. If that is the case go to our bug-report page

Debug information

In some cases you will be asked by our support-team to turn on the debug-mode to help solve specific problems.

Links

Links to interesting websites

Excel Books

The best books on Excel. Whether you want to learn Excel, write better formula's, learn how to use macros or write professionals applications in Excel these are the best books

Before I share my workbook with others I want to know if ASAP Utilities leave traces (macro/vba) behind in my files.

Published: April 26, 2007 (latest revision May 5, 2021)
reference id: QA0136

Question 1

"My company is thinking of buying some ASAP Utilities licenses and the following question has come up...
The question I have is related to Macros. Do these run in a compiled mode within Excel and leave no trace from a file perspective or do they add Macros (IE: A trace of VBA code) to each workbook that utilizes their functions?"

Question 2

"You mention that if others users don't have the software on their computer that you would have to copy/paste values the data.
For instance, if I were to copy / paste a formula or row down the remainder of the sheet, will this produce an error when shared with others?
Please explain how other non-users might be affected."

Answer

ASAP Utilities will not add macros/VBA to you Excel files. However there are two cases in which you need to have ASAP Utilities installed to use certain functionality:

  1. If you use worksheet formulas from the ASAP Utilities function library in your workbook, you will see #NAME? is you open the file on a computer without ASAP Utilities.  This is because the functions can only produce a result if ASAP Utilities is available in Excel. This limitation only applies to the worksheet functions from ASAP Utilities. You can recognize these functions because they all start with =ASAP...().
    More information and how to deal with this is on the following page:
    https://www.asap-utilities.com/asap-utilities-worksheet-functions.php#remarks-on-calculation

  2. If you create an index page of a workbook with charts.
    In Excel you cannot create a hyperlink to a chart-sheet. ASAP Utilities has made a workaround for this by using a macro for this. When you click on the link to the chart-sheet, your workbook will look for a macro that is in ASAP Utilities and this macro will take you to the appropriate chart-sheet. However as a side effect this means that if your workbook contains chart-sheets and you give it to somebody that doesn't have ASAP Utilities, they will get an error-message stating that the macro cannot be found when selecting the link to the chart on the index-sheet.
    More information:
    https://www.asap-utilities.com/asap-utilities-excel-tools-tip.php?tip=26&utilities=Sheets

 

All the other utilities do not affect your workbook in a way that ASAP Utilities is needed on the computer where the workbook is used.






« back


Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us