General Consultant Discussion

 View Only

  • 1.  MS Query No Longer Displays in Excel under Get Data

    Posted 07-08-2024 13:22

    MS Query No Longer Displays in Excel under Get Data | Other Sources due to Microsoft changes.  I experienced this a while back and I found articles that Microsoft took this out and considered it legacy.  I still cannot find it directly thru Excel.  I now have a shortcut on my desktop and my clients servers to use MS Query found under C:\Program Files\Microsoft Office\root\Office16\MSQRY32.exe.  This works, however it is an extra step.  Has anyone found how to get to it directly thru Excel when using 365.



    ------------------------------
    [Michele] [Herzog] [CPA,CITP, CGMA]
    [Overland Park] [KS]
    [816-520-1365]
    ------------------------------


  • 2.  RE: MS Query No Longer Displays in Excel under Get Data

    Posted 07-08-2024 13:57
    Edited by Kevin Moyes 07-08-2024 13:56

    You can enable it in Excel Options (click File... then look in the lower left for Options).



    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 3.  RE: MS Query No Longer Displays in Excel under Get Data

    Posted 07-08-2024 14:04

    Need to activate some fields under Excel Options data setup.  Then when you select get data, the legacy wizards will appear.  Screen shots below.

    Apparently, Microsoft wants users to start using power queries.

    FWIW, there is a 90M thread about this a couple months back.



    ------------------------------
    Jeff Schwenk
    Bottomline Software, Inc.
    (540) 221-4444
    ------------------------------



  • 4.  RE: MS Query No Longer Displays in Excel under Get Data

    Posted 07-08-2024 14:20

    Thank you so much @Kevin Moyes and @Jeff Schwenk.  This makes it easier.  I missed the earlier post.



    ------------------------------
    [Michele] [Herzog] [CPA,CITP, CGMA]
    [Overland Park] [KS]
    [816-520-1365]
    ------------------------------

    Original Message


  • 5.  RE: MS Query No Longer Displays in Excel under Get Data

    Posted 11-06-2024 09:54

    Slightly different twist to this issue.  Client's server has Excel installed.  All of the legacy import wizards appear EXCEPT Excel.  Strangely, this version of Excel does not consider the Excel query to be a legacy.  I finally found it under "Other Sources".  Is there any rhyme or reason for this location?



    ------------------------------
    Jeff Schwenk
    Owner
    Bottomline Software, Inc.
    Waynesboro VA
    (540) 221-4444
    ------------------------------

    Original Message


  • 6.  RE: MS Query No Longer Displays in Excel under Get Data

    Posted 11-07-2024 06:33

    I just checked mine and it's still under Legacy (for a newer build). I guess they keep changing their minds:



    ------------------------------
    Steve Iwanowski, NextStep Technology Advisors, aka DSD Lancaster PA ¯\_(ツ)_/¯
    ------------------------------

    Original Message


Related Content