Solved Strange icons in my excel module

January 10, 2013 at 03:53:37
Specs: Windows 7

Hi

Ive got strange Icons in my excel module

They seem to appear when u have cut and paste from a web page When u right click them the Picture Toolbar appears. If u right click and then CUT after about 20 goes they dissapear

If there an easier way of getting rid of them

Thanks


See More: Strange icons in my excel module

Report •


#1
January 10, 2013 at 04:39:46
✔ Best Answer

The following procedure will select and delete all objects (pictures, text boxes, etc.) in a spreadsheet. Note that it will select and delete all objects, so if you have objects that you want to keep, this may not work for you.

Let us know if this works.

Press F5, then click Special, then check Objects, then click OK, then press delete.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
January 10, 2013 at 05:34:43

OH Yes Oh Yes its been bugging me for weeks Thanks

Report •

#3
January 10, 2013 at 07:12:52

Funny story about that method...

I discovered this procedure when we moved from Excel 2003 to Excel 2010 at work.

We have hundreds upon hundreds of spreadsheets for our clients that had been replicated from each other year after year. When we moved to 2010 and clicked in certain cells we started seeing 2 little circles like an object had been selected.

What we found was that there were upwards of 3000 drawing object lines of varying lengths and angles that had some how ended up in the files. These lines were being replicated over and over again as we used old files as templates.

I researched a way to get rid of them all at once and found the F5 method. The major impact of this was that files were were close to 500KB with the lines were reduced to 50KB without them.

I had often wondered why the fairly simple spreadsheets were so large, but never figured it out until we moved to 2010. It's incredable the amount of disk space we are wasting because of the hundreds, if not thousands of files that are 10 times larger than they need to be.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions


Ask Question