- Local time
- 6:00 AM
- Posts
- 5,164
- Location
- Hafnarfjörður IS
- OS
- Windows XP,10,11 Linux (Fedora 42&43 pre-release,Arch Linux)
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,10,11 Linux (Fedora 42&43 pre-release,Arch Linux)
- Computer type
- PC/Desktop
- CPU
- 2 X Intel i7
- Screen Resolution
- 4KUHD X 2
