Microsoft in their wisdom decided to remove MSQuery from the Other Data sources list and are now treating it as legacy. Here are the steps to enable it again.
1. Open MS Excel and click on the File menu at the top
2. Click on Options
3. Click on Data
4. Make sure the From Microsoft Query (Legacy) is ticked and click Ok
5. Close Microsoft Excel
6. Log off from Synergetic Desktop
7. Log back on to Synergetic Desktop and Open MS Excel. You should now have Microsoft Query available under the legacy wizards
