|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.