Excel Delete Embedded Picture

HELLO ALL...

Please refer to the attached spreadsheet file.  Somehow, someway, these "picture objects" got embedded onto one of our "Template" spreadsheets...which we use for LOTS of purposes.  This is *incredibly* annoying...and we've searched the web for answers...nothing works.  Please help!...Thanks!...Mark
EMBEDDED-OBJECT.xlsx
datatechcorpAsked:
Who is Participating?
 
byundtConnect With a Mentor Commented:
datatechcorp,
While you may not think that your file is a Shared workbook, you are wrong in that regard. Note how the title bar for the window says [Shared].
Shared workbook
Please save the file with a different name or to a different location. When you do so, the Review...Share Workbook menu item is no longer greyed out. You may then follow the directions as I posted for unsharing it and deleting the objects.

Brad
0
 
JohnBusiness Consultant (Owner)Commented:
No and any attempt to delete (I deleted 2 by deleting sheet columns) broke my Excel (Excel stopped working). The third one was impossible to delete.

Delete the workbook and make a new template fresh.


... Thinkpads_User
0
 
JohnBusiness Consultant (Owner)Commented:
I was able to copy the template piece and paste into a different area. The objects do not seem to be embedded in the template - just the sheet itself.

Copy the template into a new workbook and see how much you can save.

.... Thinkpads_User
0
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

 
byundtCommented:
The workbook is Shared. If you remove the sharing, you can delete the images (there are quite a number of them, superimposed on top of each other).

To remove the sharing and delete the images:
1.  Click on the Review...Share workbook menu item
2.  In the Editing tab, uncheck "Allow changes by more than one user at the same time"
3.  The workbook will then be saved
4.  Rightclick and delete the images, one by one
EMBEDDED-OBJECT.xlsx
0
 
BasheerptCommented:
Is this a protected sheet?
0
 
datatechcorpAuthor Commented:
No, it is not a protected Sheet...and, no, when we go to the <Review> tab...EVERYTHING is greyed out...so we CANNOT "unshared" anything.  Any other thoughts?  This is just crazy!???
0
 
datatechcorpAuthor Commented:
I just cannot believe...that this should be so difficult...amazing Microsoft...
0
 
JohnBusiness Consultant (Owner)Commented:
Did you try copying the template to a new sheet? I was able to copy and paste the template to a different area.

.... Thinkpads_User
0
 
datatechcorpAuthor Commented:
OBG Brad...THANK YOU!!!  This has been driving us absolutely *batty* for so long...it worked, and is VERY MUCH appreciated!  Again, Thanks!...Mark
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.