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

There doesn't seem to be a global 'undo' for some actions made by ASAP Utilities

Published: June 28, 2005 (latest revision June 8, 2021)
reference id: QA0040

Most, but not all tools in ASAP Utilities have an undo

We didn't just turn-off the undo or something like that; Excel (even the most recent version; Excel 2019/365) has no built in automatic undo for macros.
We are aware of the importance of global undo capabilities and have provided undo-functionality for most of the tools in ASAP Utilities.

Because many, but not all tools in ASAP Utilities have an undo it is a good practice to try out ASAP Utilities with non-critical data before relying on it. Or save your work before you try something new with ASAP Utilities.

No undo in macros by design of Excel

By design Excel nearly always clears the undo when you run a macro. ASAP Utilities basically is a bundle of many macros. If you run a macro you will see that the undo-history is reset and the undo-button is disabled.

To enable undo for macros we have to write our own undo routine. Usually this is a routine that stores the settings before running the macro and sets the undo to run another routine that restores the original settings. Excel doesn't allow multi-step undo for programmers so only the last action in ASAP Utilities can be undone (if available).

If you need to undo changes that were made prior to running an ASAP Utilities tool that does not have an undo, then the only option is to close the workbook without saving. This will revert back to the original version, but all changes made during the session will be lost.

Depending on the tools in ASAP Utilities some of the custom undo-routines are relatively simple and have been implemented. However some of the operations require complex undo-procedures that have not yet been implemented because they are simply too difficult or complex to create.

Since ASAP Utilities is under constant development perhaps the undo you are missing right now is implemented in the next version.

References






« back


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