SOLVED

Microsoft Excel - Get external data from web not showing

%3CLINGO-SUB%20id%3D%22lingo-sub-401209%22%20slang%3D%22en-US%22%3EMicrosoft%20Excel%20-%20Get%20external%20data%20from%20web%20not%20showing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-401209%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20link%20external%20information%20from%20a%20url%20to%20my%20Excel%20spreadsheet%2C%20but%20for%20whatever%20reason%20the%26nbsp%3B%22Get%20data%20from%20Web%22%20option%20is%20not%20showing%20up%20on%20my%20menu.%20Does%20anyone%20have%20any%20idea%20why%20this%20might%20be%20happening%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20attached%20a%20screenshot%20of%20what%20I'm%20getting.%20Shouldn't%20that%20option%20be%20appearing%20between%20the%20%22From%20HTML%22%20and%20%22From%20Text%22%20options%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20on%20Microsoft%20Excel%20for%20Mac%2C%20version%2016.23%20(19.03.09)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%2C%3C%2FP%3E%3CP%3EPedro%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-401209%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20Apps%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-414741%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Excel%20-%20Get%20external%20data%20from%20web%20not%20showing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-414741%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20anyone%20at%20all%20that%20could%20help%20with%20this%3F%3C%2FP%3E%3CP%3EIt's%20driving%20me%20mad%2C%20I%20don't%20understand%20why%20I%20can't%20see%20that%20option%20on%20my%20menu...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-414764%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Excel%20-%20Get%20external%20data%20from%20web%20not%20showing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-414764%22%20slang%3D%22en-US%22%3EI%E2%80%99d%20suggest%20posting%20this%20in%20the%20excel%20forum%20too!%20There%E2%80%99s%20some%20true%20excel%20gurus%20in%20there!!%3CBR%20%2F%3E%3CBR%20%2F%3EAdam%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-414770%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Excel%20-%20Get%20external%20data%20from%20web%20not%20showing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-414770%22%20slang%3D%22en-US%22%3E%3CP%3EI%20see.%20Should%20I%20just%20post%20a%20new%20message%20there%20or%20is%20there%20a%20way%20to%20to%20move%20this%20topic%20onto%20that%20forum%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-414809%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Excel%20-%20Get%20external%20data%20from%20web%20not%20showing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-414809%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F72542%22%20target%3D%22_blank%22%3E%40adam%20deltinger%3C%2FA%3E%26nbsp%3Bactually%2C%20how%20do%20I%20even%20access%20the%20the%20Excel%20forum%3F%20There%20doesn't%20appear%20to%20be%20one%20on%20the%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EApologies%20for%20being%20a%20noob%20here%2C%20and%20thanks%20in%20advance%20for%20your%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPedro%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-414885%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Excel%20-%20Get%20external%20data%20from%20web%20not%20showing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-414885%22%20slang%3D%22en-US%22%3EPick%20communities%20up%20in%20the%20list%20then%20excel%20%3A)%3C%2Fimg%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-414908%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20Excel%20-%20Get%20external%20data%20from%20web%20not%20showing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-414908%22%20slang%3D%22en-US%22%3E%3CP%3EWill%20do%2C%20many%20thanks%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F72542%22%20target%3D%22_blank%22%3E%40adam%20deltinger%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hello,

 

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)

 

Thanks in advance,

Pedro

 

6 Replies
Highlighted

Is there anyone at all that could help with this?

It's driving me mad, I don't understand why I can't see that option on my menu...

Highlighted
I’d suggest posting this in the excel forum too! There’s some true excel gurus in there!!

Adam
Highlighted

I see. Should I just post a new message there or is there a way to to move this topic onto that forum?

Highlighted

@adam deltinger actually, how do I even access the the Excel forum? There doesn't appear to be one on the list.

 

Apologies for being a noob here, and thanks in advance for your help.

 

Pedro

Highlighted
Solution
Pick communities up in the list then excel :)
Highlighted