Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do I delete thousands of pictures that are somehow embedded i.
how do I delete thousands of pictures that are somehow embedded in excel?
They are just simple dots, but there are over 6000 and growing rapidly make the file size huge. |
#2
|
|||
|
|||
You could try to select the pictures this way:
Choose EditGo To Click the Special button Select Objects, click OK Then, press the Delete key, to delete the selected objects. If that doesn't work, they may be objects from the Control toolbox. To select them, Choose ViewToolbarsControl Toolbox Click the Design mode button Then, follow the steps above, to select and delete the objects. Jim Harris wrote: how do I delete thousands of pictures that are somehow embedded in excel? They are just simple dots, but there are over 6000 and growing rapidly make the file size huge. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
If you want to get rid of all the objects...
Edit|goto|Special|select objects and hit the delete key. But you may want to investigate why the number is getting larger. This isn't usual behavior. Jim Harris wrote: how do I delete thousands of pictures that are somehow embedded in excel? They are just simple dots, but there are over 6000 and growing rapidly make the file size huge. -- Dave Peterson |
#4
|
|||
|
|||
Thanks for your help, the 1st option selected all of the pictures and the
delete was easy. Now the tougher question, what could cause the pictures to be inserted in the first place and what cause's it to keep replicating. Jim Harris "Debra Dalgleish" wrote: You could try to select the pictures this way: Choose EditGo To Click the Special button Select Objects, click OK Then, press the Delete key, to delete the selected objects. If that doesn't work, they may be objects from the Control toolbox. To select them, Choose ViewToolbarsControl Toolbox Click the Design mode button Then, follow the steps above, to select and delete the objects. Jim Harris wrote: how do I delete thousands of pictures that are somehow embedded in excel? They are just simple dots, but there are over 6000 and growing rapidly make the file size huge. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#5
|
|||
|
|||
Maybe you're copying and pasting cells on which the pictures sit.
They might be pictures, or charts, or controls that were reduced in size when columns/rows were adjusted. Now they appear as small dots. Jim Harris wrote: Thanks for your help, the 1st option selected all of the pictures and the delete was easy. Now the tougher question, what could cause the pictures to be inserted in the first place and what cause's it to keep replicating. Jim Harris "Debra Dalgleish" wrote: You could try to select the pictures this way: Choose EditGo To Click the Special button Select Objects, click OK Then, press the Delete key, to delete the selected objects. If that doesn't work, they may be objects from the Control toolbox. To select them, Choose ViewToolbarsControl Toolbox Click the Design mode button Then, follow the steps above, to select and delete the objects. Jim Harris wrote: how do I delete thousands of pictures that are somehow embedded in excel? They are just simple dots, but there are over 6000 and growing rapidly make the file size huge. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can't insert, delete or move pictures | Excel Discussion (Misc queries) | |||
Cannot delete a macro | Excel Discussion (Misc queries) | |||
How to delete macros | Excel Discussion (Misc queries) | |||
delete row contains specific word in an macro | Excel Discussion (Misc queries) | |||
Saving to a network share without delete permssions | Excel Discussion (Misc queries) |