- Local time
- 5:11 PM
- Posts
- 6,012
- Location
- Hafnarfjörður IS
- OS
- Windows XP,11 Linux Fedora Rawhide pre-release 46
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
At a glance
Windows XP,11 Linux Fedora Rawhide pre-releas...2 X Intel i7
- OS
- Windows XP,11 Linux Fedora Rawhide pre-release 46
- Computer type
- PC/Desktop
- CPU
- 2 X Intel i7
- Screen Resolution
- 4KUHD X 2
