Office on Mac really is a problem. Not sure how to introduce a web query? When I click Data, Get External Data, it does not allow you to point to Internet. It stays it the Computer itself. Even when I tried to introduce a HTML based query, it does not point to the Internet.

The command Refresh Data is present and when I click it, it seems to be updating some old data. To be precise, it is going back to data from 14th December always.

Is there somebody who can help on this? This is becoming frustrating.