I have a client that has an excel sheet that they have been using forever. Seems like every month one of the workbooks gets very hard to manipulate. Going from cell to cell takes a few seconds it takes a while to select a set of cells.
Now here is the kicker, to fix this I have been taking the workbook selecting all the data and doing a paste special values and source formatting into a fresh workbook it works fine. I delete the old workgroup from the file and all is well for about a month. Also afterward I notice that the excel file is significantly smaller.
This wont work with a standard paste, that seems to bring the problems with it. So I am thinking excel has some sort of temp or cached data it hold onto that I can't clear. This sheet is very important and I don't want to have to do this every month any ideas?
Keep Up with TechRepublic