I have a file, which somehow is 8.59mb in size, and has almost nothing in it.
I have data in range A1:F29.
I deleted rows 30:63556 (last row in worksheet) and also deleted columns G:IV (last column).
No reduction in filesize.
I then copied the data (range A1:F29) to a new workbook. Filesize then goes to 55kb.
What the heck. Why, if I deleted all the cells outside that range in the first file, are the files not the same size???
I created the first file from a blank workbook, and its just a mockup for a new layout template for files at work.
There are no links, or anything but a small range where i entered dummy text and formatted a few cells (borders, font).
I have data in range A1:F29.
I deleted rows 30:63556 (last row in worksheet) and also deleted columns G:IV (last column).
No reduction in filesize.
I then copied the data (range A1:F29) to a new workbook. Filesize then goes to 55kb.
What the heck. Why, if I deleted all the cells outside that range in the first file, are the files not the same size???
I created the first file from a blank workbook, and its just a mockup for a new layout template for files at work.
There are no links, or anything but a small range where i entered dummy text and formatted a few cells (borders, font).