I'm running V2019 Pro plus Office 10. Copying a section of an Excel file, doing a paste special into V2019 or Word, closing the open Excel file, then dbl clicking the worksheet object in either Visio or Word opens the Excel app and the contents for editing. This makes me believe that either Office16 behavior has been changed, or there's a bug, or there's perhaps a setting somewhere in the Office apps, e.g., Excel, that hasn't been set properly.
Pretty sure this isn't a Visio issue...don't recall it coming up on the forum before.