Excel files have objects that can not be deleted

[AijaV]

Hi!
I would appreciate if someone could help me 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 Windows versions.

I've also tried this:

• Web page preview. Inspect. Result

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



When I use VBA code (ActiveSheet.Shapes.Creator) to find out creator, the result is


1480803660
The Excel for Macintosh creator code.

How could I solve this problem? I have a lot of files, obviously that has been created or at some point used on Macintosh device, but now I have problems with them on Windows devices to use some add-ins because of this error. Is there any repair option that could be applied to files to delete those objects?

Thank you in advance!

 

[JumboCactuar]

Just an idea but backup first,
Rename your file extension to .zip
Extract contents and delete objects manually
Re-zip and change extension back.

 

[AijaV]

Additional info to my question because of the mistakes in my text that I see after posting

1. Result of web page preview of one excel file object was [FONT=&quot]img width="421" height="866" src="image002.png" v:shapes="Object_x0020_1"
[/FONT]2. VBA code counted 1 object when that was the only object on the sheet[FONT=&quot]
[/FONT]

 

[AijaV]

Here is list of the extracted files
[FONT=&quot][/FONT][FONT=&quot][/FONT]
where I can find and delete objects.
never dones something like this before

 

[sandy666]

Post a link to this file, shared on dropbox, google drive , one drive or any similar server

 

[AijaV]

Post a link to this file, shared on dropbox, google drive , one drive or any similar server

Here is the link
https://1drv.ms/x/s!AhOi6ZgK_C5DgVjh7vyMut-e7iLw

 

[AijaV]

I've used this as solution for now

Selected all tabs in workbook and with Move or Copy copied to new workbook. This action moves all data and formats and the good thing that it does not move these objects with errors. But I wanted to know maybe there is a better way.

 

[sandy666]

select column A and B
Delete these columns

or

change extension to .zip
open zip
from xl folder delete Drawings folder
close
change extension to xlsx
open
accept recover/repair

 

[AijaV]

select column A and B
Delete these columns

When I do so, object remains, I just can't see it on the sheet anymore, but I can see it with the selection pane. And still have problems to use com add-in.

 

[sandy666]

re-read post above