Solved EXCEL get data via MsQuery -- permanent decent fix for missing Msquery in EXCEL get data (solved finally)


jimbo45

Well-known member
Pro User
VIP
Local time
10:23 AM
Posts
4,083
Location
Hafnarfjörður IS
OS
Windows XP,7,10,11 Linux Arch Linux
Hi folks

in EXCEL from the Files menu go to options and select these 2 items from show legacy data import wizards.

Screenshot 2024-04-19 013257.png


now restart excel data->get data

You'll see a new option legacy wizards with Microsoft query as an option.


Screenshot 2024-04-19 013756.png


Then it all works properly as before in EXCEL with all the formatting options etc etc.

Screenshot 2024-04-19 014340.png

Q.E.D -- but why Ms hide or obfuscate a useful function that people have been using regularly for at least over 20 years --- BONKERS.
Anyway problem now solved.

Cheers
jimbo
 

Attachments

  • Screenshot 2024-04-19 014340.png
    Screenshot 2024-04-19 014340.png
    43.9 KB · Views: 0

My Computer

System One

  • OS
    Windows XP,7,10,11 Linux Arch Linux
    Computer type
    PC/Desktop
    CPU
    2 X Intel i7
Back
Top Bottom