Captain’s Blog, 181208.1 – Thanks for the help Excel 2016/2019, but please stop thinking for me

” “Thinking” that I must have “forgotten” to include columns G to I, Excel auto-adjusts the formula to include those columns. It matters not that the formatting in H and J mark them out as “something different to B to F”. It matters not that it makes the formula in J17 inconsistent with the formulas above. Oh no. It auto-adjusts the formula anyway…”

Captain’s Blog, 180902.1 – Disappearing Space on Your SSD Drive, and Hidden Files

“…anything in C:\Windows\Temp should be counted in the 107 gigabytes above, right? Because it’s IN one of the folders that I queried, right?

Right??

No. Windows is lying to you. Unless you go to C:\Windows\Temp, double click on it and explicitly grant yourself permission to it then Windows will hide not only the contents of the folder but also the file count and size of the files therein.”