datatechcorp
asked on
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
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
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
Copy the template into a new workbook and see how much you can save.
.... Thinkpads_User
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
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
Is this a protected sheet?
ASKER
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!???
ASKER
I just cannot believe...that this should be so difficult...amazing Microsoft...
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
.... Thinkpads_User
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
OBG Brad...THANK YOU!!! This has been driving us absolutely *batty* for so long...it worked, and is VERY MUCH appreciated! Again, Thanks!...Mark
Delete the workbook and make a new template fresh.
... Thinkpads_User