Error in Excel: ASAP Utilities – delete all objects on current worksheet
I faced the following error message when I am trying to use certain workbooks:
Error -2147319765: Automation error
An 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 may not be used for this function. This could be due to macros with errors in your file. You may try it again by re-opening your workbook without enabling the macros in it. Other reason could be a bug in excel, for that case you can try to copy the information from your current worksheet to a new worksheet. Then run the utility again. A solution could also be to put your worksheet in visual basic/Developers ‘design mode’ and then run the utility again.
Need a solution about this error. Please help. Thanks a lot.