May 22 2019 01:00 PM
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.
May 22 2019 01:16 PM