Hi folks
in EXCEL from the Files menu go to options and select these 2 items from show legacy data import wizards.
now restart excel data->get data
You'll see a new option legacy wizards with Microsoft query as an option.
Then it all works properly as before in EXCEL with all the formatting options etc etc.
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
in EXCEL from the Files menu go to options and select these 2 items from show legacy data import wizards.
now restart excel data->get data
You'll see a new option legacy wizards with Microsoft query as an option.
Then it all works properly as before in EXCEL with all the formatting options etc etc.
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
My Computer
System One
-
- OS
- Windows XP,7,10,11 Linux Arch Linux
- Computer type
- PC/Desktop
- CPU
- 2 X Intel i7
