Heh, the Web Query feature in Excel hasn't been significantly touched since it was introduced in Office 97 (or was it 2000?) - I know because when I was at MS a few years ago I reported a bad bug in the Web Query feature - it wasn't a regression, just something inherent in the fact they're stuck using the old Trident MSHTML engine and so the Web Query feature was broken for newer websites - they closed my bug as a WONTFIX because it wasn't a regression - even though the state of that tool in Excel gets worse each year Chrome's usage figures go up... I contacted one of the devs on the team seeking an explanation, he summarized it as stale code no-one wanted to touch without risking breaking anything.
It's telling that most of Excel's major new features in the past few releases (e.g. PowerQuery, integration with PowerBI, etc) are all implemented as pop-up "child applications" with their own UI instead of being baked into Excel itself - I wonder how long they'll keep this up before rewriting it entirely.
It's telling that most of Excel's major new features in the past few releases (e.g. PowerQuery, integration with PowerBI, etc) are all implemented as pop-up "child applications" with their own UI instead of being baked into Excel itself - I wonder how long they'll keep this up before rewriting it entirely.