Excel for Mac Version 16.35 -neue Abfrage - aus anderen Quellen - aus dem Web fehlt auf einmal

[Dorieen]

Hallo ich habe ein Problem in Excel eine neue Datenabfrage aus andere externe Quellen zuzugreifen bzw. zu nutzen. Ich möchte in mein Arbeitsblatt Daten aus einer Google Tabelle abfragen. ( Aktienkurse)

 Office 365 

 

Diese Funktion ist nicht mehr sichtbar für mich. Ich möchte in Excel eine Url als externe Datenquellen integrieren. Es ging schon mal,  nun nicht mehr. In dem einen Screenshot sieht man das es fehlt. 

Hier eine Screenshot wie es aussehen muss.  

 Habe Ihr Vorschläge? Habe schon Excel deinstalliert und neu installiert. 

[#2]

Hi @Dorieen 

Currently Excel For Mac Supports Query queries in your workbook that pull data from Text, CSV, XLSX, XML or JSON files. Your Queries must be build in the Excel For Windows.

Above Image is for Excel For Windows showing which queries are supported in Excel for Mac

Currently the Query Excel for Mac is in phase one, you can see the link for details.

Article - https://techcommunity.microsoft.com/t5/excel-blog/get-amp-transform-power-query-in-excel-for-mac-pha...

Video [Steps to Run Power Query On Mac]- https://youtu.be/1VRrPPkMGs8

--------------------------------------------------------------------------------

If you are trying to use Run Web Query the please follow this

1. Go to a Website that has Web tables that you want to put in Excel.

2. Copy the web-address .

3. Open to Microsoft Word & Select a new document.

4. Paste the URL into the Word document.

5. Save the file as Plain Text. 

6. Open will Pop-up, select the file MS-DOS>OK
7.  
8. Select the file and change the extension from .txt to .iqy (The .iqy file extension signifies that the file is a Web query for Microsoft Excel.)

Once your Web query is saved, follow the steps to Run the Web query on Excel for Mac:

1. Open Excel.

2. Go to > Data > Get External Data > Run Web Query
3. 

4. Open the .iqy file which you have saved it.

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer.

[#3]

If you find the above solution resolved your query don't forget mark as Official Answer.

[#4]

"Your Queries must be build in the Excel For Windows."

@Faraz Shaikh 

I've got the same issue. How can I import data from external XLSX files without a spare Windows PC lying around?