3 ms·
A lot of the backwards compatability is jaw-dropping. Some things that were intended to be deprecated what feels like forever ago still work. [1] I also regul
by SanchoPanda 7y ago
A lot of the backwards compatability is jaw-dropping. Some things that were intended to be deprecated what feels like forever ago still work. [1] I also regularly uncover brilliant bits of spreadsheet design looking at documents made one or more decades ago. Even some old school tricks in those sheets still help me do new things.
For example the (internet explorer exclusive) right click to export to excel is still among the most reliable ways to extract data that otherwise won't play nice.
However I wish speed was higher on the priority list. For big sheets with lots of calculations Excel 2016 was SLOW. Slower than 2013 by a fair margin, and actually slower than binary based sheets on 2003 by A LOT. [2] [3] [4] Excel was my default calculator on my computer for years. But it just starts too slow now. Foreign language support is weird in that regard. [5]. And on a personal note, I'm still bitter about the ribbon.
[1] Though some dissapear, you will be kinda missed, default Powerview
[2] https://social.technet.microsoft.com/Forums/en-US/8b2a498c-ac63-40b1-937e-a9e5952ae5d9/massive-performance-decline-since-excel-2003-any-suggestions?forum=excel https://social.technet.microsoft.com/Forums/en-US/8b2a498c-a...
[3] http://dailydoseofexcel.com/archives/2015/04/07/excel-2013-vba-unreasonably-slow/ http://dailydoseofexcel.com/archives/2015/04/07/excel-2013-v...
[4] My own experience, for what it's worth.
[5] https://professor-excel.com/performance-excel-study/ https://professor-excel.com/performance-excel-study/