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

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-phase-1/ba-p/876840

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