Error : ASAP Utilities – delete all objects on current worksheet

Asked By Valerie Kely 30 points N/A Posted on - 05/29/2012

I am getting error messages with several workbooks:

Error -2147319765: Automation error

Element not found, Or an error like ' Sorry, your sheet cannot be used for this tool…'

 Error : ASAP Utilities – delete all objects on current worksheet

Sorry, your sheet somehow cannot be use for this tool.

This might be due to macros with error in your file. You can try it again by re-opening your workbook without enabling the macros in it.

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

 A solution might also be to put your worksheet in visual basic/Developers ‘design mode’ and then run the utility again.

I am trying to find a solution to this problem. If you have any I would be glad to accept your solution and recommendation. Thank you so much.

• Status: Open
• Question Views: 912
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Sharath Reddy 590495 points N/A #153332

Error : ASAP Utilities – delete all objects on current worksheet

Try following what was instructed in the dialog box. I’m sure if it weren’t for the macros that were in your workbooks it will open successfully without generating any errors. It should work next time you open it with the macros disabled.

Or you may also try opening the workbooks on a different version of the program you are using. Try opening them on an older version and or on a newer version of the program to see which will work but that is, if it’s only possible and you have those versions of it.

About Sharath Reddy

Questions
1

Answers
14599

Best Answers
2290

• Vote Up 0 Vote Down

• Posted on - 06/05/2012
• Question Category: MS Excel