I have a workbook with about 200 worksheets. Each sheet contains data for a specific entity, but the data is basically the same information on each sheet. When I replace the old data with new information, I create a temporary template sheet, work on that, then copy it over to the original sheet and delete the template. This has worked for a long time, but recently, I've noticed that my file is growing exponentially even though the number of sheets and data is the same. Anyone have this problem also.
