Feedback by UserVoice

 

How can we improve Excel for Mac?

← Excel for Mac

Excel QueryTable does not work on Excel for Mac in Version 16.9.

Excel QueryTable does not work on Excel for Mac in Version 16.9.
See example from Microsoft here: https://msdn.microsoft.com/en-us/library/office/aa203721(v=office.11).aspx
Section "Using a Static Web Query" describes a way to get data from a webserver.
If you Change the used link from http://quote.money.cnn.com/quote/quote?symbols=msft
to https://go.microsoft.com/fwlink/?linkid=859725
the example loads a web table and displays it in a Excel worksheet.
This example does not work on Mac with Excel Version 16.9. With Version 15.X on Excel the query executes successfully like on Windows.
Here is the Code snippet for reproducing the bug:

Sub RunWebQuery()
With ActiveSheet.QueryTables.Add(Connection:= _

  &quot;URL;<a rel="nofollow noreferrer" href="https://go.microsoft.com/fwlink/?linkid=859725&quot;">https://go.microsoft.com/fwlink/?linkid=859725&quot;</a>, _

     Destination:=Range(&quot;a1&quot;))



  .BackgroundQuery = True

  .TablesOnlyFromHTML = True

  .Refresh BackgroundQuery:=False

  .SaveData = True

End With
End Sub

If you Change the Line

  .Refresh BackgroundQuery:=False

to

  .Refresh BackgroundQuery:=True

the behavior is different. It seems as if synchron web queries are not implemented correctly.

11 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Dirkrlu shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

13 comments

Comments are closed An error occurred while saving the comment

Excel for Mac

Categories

Feedback and Knowledge Base

(thinking…)