Excel files have objects that can not be deleted

Question

Hi!

I need help with excel files.

In some of them I have images, in others-text boxes, that can not be deleted, selected or moved to other place. 

Accessibility checker shows error with Alt text

Check for issues result - invisible content inspection not successful

Tried to use Excel 2016 Pro, Excel 2013. I can not delete objects with that error in any of available for me MS versions.

Please help me to solve this problem. I need to delete those objects. They causing problems to use Excel.

Thank you in advance!

Answer 1

Request you to please prepare and upload a sample / dummy file sans confidential / sensitive data to Onedrive and share the link? It will help me to give prompt and right solution.

A guide to upload and share Onedrive file - https://support.office.com/en-us/article/share-...

Answer 2

Here is the link

error.xlsx

Answer 3

Tried it. When I do CTRL+G > Special > Objects > OK and then this is not detected as object.

This is also not detected as object through VBA as well.

What exactly is this, I am not sure.

Would give it another shot tomorrow.

Answer 4

Thank you! 

I've also tried this:

• Web page preview. Inspect. Result

<img width="421" height="866" src="image002.png" v:shapes="Object_x0020_1"> 

• VBA code 1

Sub count()

Dim i As Integer

i = ActiveSheet.Shapes.Count

MsgBox i

End Sub

Result. If that’s the only object in sheet I get result “1”

• VBA code 2

Sub DeleteAllShapes()

Dim Shp As Shape 

For Each Shp In ActiveSheet.Shapes 

Shp.Delete 

Next Shp 

End Sub

Result. Run time error warning

Will wait for any suggestions. Hopefully someone knows how to solve this.

Answer 5

I've got solution from another forum

changed extension to .zip

opened zip

deleted object  that caused problems

closed

changed extension back to xlsx

opened

accepted recover/repair