Forum Discussion
XLSM suddenly increased in size by four times
I have a spreadsheet that I am creating with a lot of VBA associated. I save the file with a new version number after making revisions. I noticed about 40 revisions ago that my file size jumped fro...
I wouldn't say that I have fully understood the issues but I have found that formatting an entire sheet does not cause the used range to extend and therefore the file size barely changes. I suppose it makes sense if one assumes the formatting is only actually applied to cells that are currently visible on screen so it is only the rules that are stored. If there is no end-point (your cell EE1200), there is nothing to store.