I receive error messages from certain workbooks
Hello, I receive the following error messages from certain workbooks:
Error- 2147319765: Automation error.
ASAP Utilities-on current worksheet, delete all objects.
Sorry for this tool, your sheet cannot be used somehow.
The screen shot is:
ASAP Utilities – Delete all objects on current worksheet
Sorry, your sheet somehow cannot be used for this tool.
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.
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.
This error in the file may be occurred due to macro and without enabling macros it can be tried by reopening the wordbook. Again this might be happened due to a bug in excel. In this case, you can copy the data from your current worksheet and paste those into another fresh worksheet and run the utility again.
There is also another solution resolving this issue, you may put your data of worksheet in Visual Basic/Developers ‘Design mode’ and run the utility.
Help me please.