I am trying to link external information from a url to my Excel spreadsheet, but for whatever reason the "Get data from Web" option is not showing up on my menu. Does anyone have any idea why this might be happening?
See attached a screenshot of what I'm getting. Shouldn't that option be appearing between the "From HTML" and "From Text" options?
I'm on Microsoft Excel for Mac, version 16.23 (19.03.09)
@Jan Karel Pieterse that was my first thought, but "from HTML" just prompts me to select an HTML file from a local folder. It doesn't give me the option to select a web link, which is what the "from Web" option allows.
This is so frustrating, every single tutorial I've been able to find clearly points users to the "from Web" option specifically, but it's simply nowhere to be found on my menu.