Dear Excel Gurus,
This might sound so basic but as you know, you transform a table into query by clicking the "From Table" button in the Data ribbon.
I currently have 100+ tables in my workbook and it is inefficient to transform all those tables manually one-by-one.
So, is there a way to convert all of them automatically? And, if possible Load as Data Connection only?
Thank you in advance.
Have a great day