Excel 2010 web query

Al Vazquez 21 Reputation points
2021-03-07T04:18:05.677+00:00

I'm attempting to use the Excel web query to download info from a Google Sheet. The internal browser downloads the sheet, but instead of allowing me to select data and insert in current page, the Open/Save dialog appears. If I select Save, it saves in a new Workbook. If I select Open, I get the error message "MS Excel- 'The command you selected is not available from the shortcut menu' " Scripting of some kind continues and I have to use Task Manager to terminate Excel. Suggestions?

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,639 questions
0 comments
Accepted answer
  1. Emily Hua-MSFT 27,526 Reputation points
    2021-03-08T09:56:09.93+00:00

    @Al Vazquez

    > The internal browser downloads the sheet, but instead of allowing me to select data and insert in current page

    Could you please show me the interface you encounter this issue?

    On my test environment with Office 2010 and Microsoft Power Query for Excel installed, according to the article "Using Google Sheets As Data Source In Power Query", I modify the URL, delete the /edit#gid=267133497 of the sheet and add /export?format=xlsx to the end of the URL.
    Then use From Web import the data from Google Sheet into Excel successfully as following gif.
    (Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.)

    75380-9.gif

    If your steps are same as mine, but these steps still do not work, please go to File > Options Advanced > General section > clear the Ignore other applications that use Dynamic Data Exchange (DDE) check box in the General area.

    Any updates, please let me know.

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Lz._ 8,991 Reputation points
    2021-03-07T05:55:35.077+00:00

    Hi @Al Vazquez

    See Get data from GoogleSheet I wrote some time ago. No idea if it applies to Excel 2010 with the PQ Add-in though...

    Hope this helps

    0 comments