It's not the first time that Microsoft has done something like this (remove a useful feature).
Years ago, I worked with a group of people that did inspections. We used Excel to create our reports. We used macros to do some of the tasks. One of the macros inserted photos into the report. It literally reduced the time from several hours to a couple of minutes (or less). It worked great for a long time. Then the photo macro started generating errors on some of the computers. But it worked fine on mine. Then my IT folks updated my PC to the newest MS Office. Then my computer started having the same error.
When MS updated Office, they also updated Visual Basic for Applications (which is what is used for the macros). When they updated Office, turns out, they removed several commands. One of them I used in my photo macro.
After visiting several forums, I found out that there were a lot of people that now had their macros failing because MS had removed some of the commands they used. There was no warning. We just started getting errors.
In my case, the solution was to write 3 separate routines to do what the one command did. Talk about a step backwards.