Finally updating from Excel 2011 to 2016 on a “robot” running Mojave (and as soon as I get XL working will go up to Catalina and upgrading to XL 2019/365 is feasible too). One thing that broke is being able to paste from the clipboard a block of tab-delimited text into a worksheet using “paste special” “what paste values” so the tabbing is retained. Currently it doesn’t paste at all. Works fine in 2011. I staggered upgrading XL and the OS in hopes of making troubleshooting of stuff like this a bit more straight-forward with only changing one factor at a time.
My GoogleFu turned up nothing I could action on.