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
This is an old article that has been archived.

Automation error Element not found.

Published: August 6, 2008 (latest revision September 25, 2018)
reference id: QA0188
This is an old article that has been archived.

Question

With certain workbooks I receive the following error:

Error -2147319765: Automation error
Element not found


Or an error like ' Sorry, your sheet cannot be used for this tool...'
Automation error, your sheet cannot be used for this tool

Answer

This error can occur if your workbook contains a Visual Basic project with macro errors or if it contains a lot of ActiveX components, such as buttons or checkboxes. In such a case the workbook (worksheet) might not be accessible via a macro.

You might be able to reproduce the problem by executing the following macro on such a sheet, which normally shouldn't produce an error:

Sub ShowSheetName()
      MsgBox "The name of the selected sheet is: " & ActiveSheet.Name, vbInformation
End Sub

Solutions

You can use the following workaround to make the utilities work on these files:

Solution 1

This might be due to macros with errors in your file. You can try it again by re-opening your workbook without enabling the macros in it. However this doens't always seem to solve the problem in Excel 2007.

Solution 2

Put Excel in 'Design mode' and then run the utility:

Excel 2000, 2002 and 2003

On the Visual Basic commandbar click on the 'Design mode' button.
To make the commandbar visible, right click on the Excel menu, and then check the 'Visual Basic' option.
Excel, activate the Visual Basic commandbar
Put Excel in 'Design mode'

Excel 2007

A solution might also be to put your worksheet in Visual Basic/Developers 'design mode' and then run the utility again.
In the Developer tab (click here if it is not visible) click on the 'Design Mode' button:
Put Excel in Design mode via the Developer tab

Solution 3

Another reason might be a bug in Excel.
In that case you could try to copy all the information from your worksheet to a fresh new worksheet and run the utility again.






« back


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


Empowering Excel Users Worldwide for 25 Years