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?
Bookmarks