+ Reply to Thread
Results 1 to 4 of 4

Power Query in Excel 2016 - does not open any features

  1. #1
    Forum Contributor
    Join Date
    01-18-2017
    Location
    Poznań, Poland
    MS-Off Ver
    2016
    Posts
    136

    Power Query in Excel 2016 - does not open any features

    Hi All,

    I got a problem with my Excel 2016.

    I try to open another workbook by Power Query so I click:

    Data --> New Query --> From File --> From Workbook

    but then a dialogue box does not pop up.

    Do you know what might be the problem of it? in Power BI for example I have no problem with opening a Query.

    I will be grateful for any suggestions.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    59,030

    Re: Power Query in Excel 2016 - does not open any features

    Have you tried rebooting your machine? Failing that, repairing your installation of Excel?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  3. #3
    Forum Contributor
    Join Date
    01-18-2017
    Location
    Poznań, Poland
    MS-Off Ver
    2016
    Posts
    136

    Re: Power Query in Excel 2016 - does not open any features

    Yes, I rebooted the machine and checked updates - I got latest version installed.

    I also followed the Quick repair but nothing has happened. It still does not work...

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    59,030

    Re: Power Query in Excel 2016 - does not open any features

    OK - I have no idea, sorry. Never had dialog boxes in PowerQuery not appearing on any platform I use. Sorry - I am out of ideas.

    Please update your forum user profile to Excel 2016.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Power Query, Excel 2013/ 2016, Dynamic URL, Set parameters
    By dude6571 in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 08-17-2019, 12:29 PM
  2. Subtotal in Power Query Excel 2016
    By metsmaniac in forum Excel General
    Replies: 3
    Last Post: 08-06-2019, 04:07 AM
  3. Appending Charts using Power Query Excel 2016
    By STokhi1 in forum Excel Charting & Pivots
    Replies: 13
    Last Post: 07-02-2018, 07:30 AM
  4. Sub-Forum for Excel Power Tools (Power Query, Power Pivot & Power BI)
    By chullan88 in forum Suggestions for Improvement
    Replies: 10
    Last Post: 06-28-2018, 02:25 PM
  5. Replies: 7
    Last Post: 07-25-2017, 08:38 AM
  6. automate power query update from new tab (office excel 2016)
    By ajnuna in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-18-2016, 07:27 AM
  7. Excel 2016 Database Features?
    By RangeRover in forum Excel General
    Replies: 0
    Last Post: 11-25-2015, 12:18 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1