Why Excel insert thousands of shapes object into my workboot?

I have a large workbook that I regularly run VBA to copy/paste and do queries, and a lot of insert and delete. Over time, the worksheet slows down to a crawl. I found that each worksheet has thousands of shapes objects named "Picture nnnnn". After deleting those objects, the workbook comes back to life.

Do you know why and how that Excel inserts those objects? How what do I have to do to correct them?

Your macro is creating that picture, check your macro to see how it is being created and add code to delete it once it is done using the picture.

Originally Posted by slx

Your macro is creating that picture, check your macro to see how it is being created and add code to delete it once it is done using the picture.

My codes do not explicit create shapes object.

A typical routine involves copy and paste the data from a downloaded csv file and create a temporary worksheet where I manipulate the data with queries. Then it copies the data to the main sheet and then deleted the temporary one.

There is more than 1 way to create an object, one of the ways is using copy.

Originally Posted by slx

There is more than 1 way to create an object, one of the ways is using copy.

But the source of all the copying is downloaded csv files, or text files. Is there embedded object in those files?

It was over a period of time.

I first noticed that the macro would hang up (Not responding) at a certain point. I had to save and quit before that point to continue. Then I notice that every click take a long time delay for the screen to react. I wrote a routine to find the number of shapes and found over 50000 of them in one sheet. I went ahead and wrote the routine to delete them and it's working great now.

Just want to know why.