Hello.
In an .xlsb workbook, I have a tab with 63k rows and 68 columns.
Of the 68 columns, 17 are data columns (hard-coded numbers or text) and the other 51 are formulas. The formulas are either simple "IF" statements (eg, if Column X is greater than 1, "Yes, No") or vlookups referring to very small ranges in other tabs in the workbook. None of the formulas are SUMIF or COUNTIF or anything like that.
At some point, I decided that 9 of the 51 formula columns were no longer needed, so I deleted those columns (no other cells anywhere in the workbook referred to those 9 columns). I did not change anything else anywhere in the file.
But when I saved the file, I noticed that the file size unexpectedly INCREASED from 31MB to 34MB.
So I reverted to a saved backup version, and this time I just deleted the formulas from those 9 columns, but I did not delete the columns themselves (in other words, the tab still has 68 columns, but now 9 of them have nothing but empty cells).
In this case, the file size DROPPED from 31MB to 28MB.
Anything ideas on what is causing this behavior?
Version: Excel 2016 64-bit, Microsoft Office Professional Plus 2016
Thank you.
In an .xlsb workbook, I have a tab with 63k rows and 68 columns.
Of the 68 columns, 17 are data columns (hard-coded numbers or text) and the other 51 are formulas. The formulas are either simple "IF" statements (eg, if Column X is greater than 1, "Yes, No") or vlookups referring to very small ranges in other tabs in the workbook. None of the formulas are SUMIF or COUNTIF or anything like that.
At some point, I decided that 9 of the 51 formula columns were no longer needed, so I deleted those columns (no other cells anywhere in the workbook referred to those 9 columns). I did not change anything else anywhere in the file.
But when I saved the file, I noticed that the file size unexpectedly INCREASED from 31MB to 34MB.
So I reverted to a saved backup version, and this time I just deleted the formulas from those 9 columns, but I did not delete the columns themselves (in other words, the tab still has 68 columns, but now 9 of them have nothing but empty cells).
In this case, the file size DROPPED from 31MB to 28MB.
Anything ideas on what is causing this behavior?
Version: Excel 2016 64-bit, Microsoft Office Professional Plus 2016
Thank you.