As you get more proficient at Excel, sometimes a Workbook will have many sheets and get very large is size.
Large workbooks are slow to load, save, recalculate and often don't really have that much information. I developed a spreadsheet to identify the specific sheet or code that's causing the issue. I'll be developing a number of lessons on how to develop this tool. You will also get access to the tool so you can shrink large spreadsheets yourself. Below is the output generated from the sheet. As you can see below the total size of the file is 8.5 megabyte (mb) and the top 5 are using 61% of the 8.5mb.
|