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.

You could try to select the pictures this way:

Choose Edit>Go 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 View>Toolbars>Control 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

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

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 Edit>Go 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 View>Toolbars>Control 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
>
>

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 Edit>Go 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 View>Toolbars>Control 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