I run a web query that imports ~44,000 rows of plain text data into columns A:Q, then runs some basic sorting on it (and copies a portion of it to other sheets, but that's not important.)
I couldn't figure out why this file had grown to 18MB in size. 44,000 rows of data is a lot, but even when I deleted all the contents of columns A:Q, the file was still ~12MB in size.
Some trial and error uncovered this really weird artifact: when I cleared the formatting from those empty A:Q columns (Highlight A:Q > Clear > Clear Formats), my file size dropped to ~3MB. There's no weird conditional formatting or anything. As far as I can tell, the ONLY formatting that had ever even been applied to those columns was some Left/Right/Center alignment or Number/2-decimal or the like.
How can I drill down to discover what formatting my file thinks is being applied to those columns that could possibly consume 9MB in file size?
I couldn't figure out why this file had grown to 18MB in size. 44,000 rows of data is a lot, but even when I deleted all the contents of columns A:Q, the file was still ~12MB in size.
Some trial and error uncovered this really weird artifact: when I cleared the formatting from those empty A:Q columns (Highlight A:Q > Clear > Clear Formats), my file size dropped to ~3MB. There's no weird conditional formatting or anything. As far as I can tell, the ONLY formatting that had ever even been applied to those columns was some Left/Right/Center alignment or Number/2-decimal or the like.
How can I drill down to discover what formatting my file thinks is being applied to those columns that could possibly consume 9MB in file size?