Share via

How to Get External Data from Web in Excel 2016 for mac V15.22

Anonymous
2016-06-05T03:05:04+00:00

Hi,

I have MS Excel 2016 V 15.22 in my MAC PC. but when I got to Data, External Data, I dont see the option "From Web". How can i import data (for instance stock prices) from Web into my excel sheet in this version of excel.

Is there any alternative

thanks

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  2. Jim G 134K Reputation points MVP Volunteer Moderator
    2016-06-06T15:37:43+00:00

    Yes, there is an alternative, but Arshad's method is so wildly incorrect I deleted his answer.

    You'll find the answer you are seeking in the responses to this question:

    http://answers.microsoft.com/en-us/mac/forum/macoffice2016-macexcel/can-no-longer-get-stock-quotes-in-excel-2016-on/20a74032-28c7-4962-8904-61b171b726fb

    8 people found this answer helpful.
    0 comments
  3. Anonymous
    2017-05-17T22:27:15+00:00

    That solves the stock prices issue, but I need to import data from a exchange rates page. How can I do it?

    0 comments
  4. Jim G 134K Reputation points MVP Volunteer Moderator
    2017-05-19T15:58:27+00:00
    2 people found this answer helpful.
    0 comments
  5. Anonymous
    2017-07-24T23:32:42+00:00

    Does anyone know what happened to the "From Web" function? I had it a few weeks ago, and then it's gone out of nowhere. Office 2016. Very strange.

    2 people found this answer helpful.
    0 comments