Excel running into problems with excel com addin

Question

I have this issue with one excel file that is made  in2016, but now when I am using Excel Com add-in, Excel runs into problems and I need to disable that add-in. With Selection pane I found that I have on one Sheet picture (object 1) that can not be displayed (error - no Alt text), selected nor deleted. Any ideas how to remove that object, so that I can use my file without problems?

Thank you

Answer 1

Hi,

I'm Diego Rios, an Independent Advisor willing to help other Microsoft customers.

You can try the following procedures:

Try working with the Word Safe mode and check if it helps.

Hold the windows key + Letter ‘R’ on the keyboard to launch the Run command > Copy and paste the following command line in the open box and click Ok.

For Excel: Type excel /safe, and click OK.

For Outlook: Type outlook /safe, and click OK.

For Word: Type winword /safe, and click OK.

For PowerPoint: Type powerpnt /safe, and click OK.

For Publisher: Type mspub /safe, and click OK.

For Visio: Type visio /safe, and click OK.

If, word works properly do you need to disable add-ins:

Go into Word / Excel/ PW:

Click on File menu.

Click Options.

Click Add-ins.

Click on Go button besides Manage: Com-Add-in.

Check if there are add-ins listed, clear the checkbox to disable them.

Close the Word and restart it.

In the link below explain how disable add-in:

https://support.office.com/en-us/article/view-m...

If, the procedures above didn't work, I refer to repair Office in the following link for more information:

Go to Control Panel >> Add and Remove Programs and highlight Microsoft Office. Click on Remove. A menu will pop up allowing you to choose repair or reinstall. Try a Repair Online and verified after repair it fix.

http://office.microsoft.com/en-us/excel-help/re...

Please let me know if this helped and works.

Best Regards,

Diego R.

Answer 2

and one more

this image can not be displayed, in selection pane list is that object, but it can not be selected or deleted, I can just hide it. the other one - check box - I can select and delete.

Answer 3

I am adding some screenshots

Inspection of invisible content did not complete succsesfully

Answer 4

Thank you Diego for your advice!

Tried all this already. Did not solve my problem. Also Selected all cells in worksheet cleaned all Formats, Values, hyperlinks, but that object stays and I have no idea, how to get rid of it. Only when I move my sheet to new workbook, all data except from that object moves to new book and then I can without problems use my excel com add-in in that new book,  but old one runs into problem

I think that object in my file is somehow broken. Because I can not select it, move or delete it. Is there any vba code to clean all objects with errors from workbook?