Excel remove table, Keep data query

Does anyone know how to remove a table format from Excel 2016/365 but keep the data query behind it?
Who is Participating?
jkpieterseConnect With a Mentor Commented:
You can turn the formation of structured references in formulas off in tools, options, Formulas, "Use Table Names in formulas".
There are many advantages in using tables. Too many not to use them IMO.
I'm afraid that is not possible, unless you want to save the file as filetype .xls, which risks loosing all sorts of other functionality.
Why are you asking?
HKFueyAuthor Commented:
Creating a formula based on table results in a long and often un-decipherable string!
abbas abdullaConnect With a Mentor Commented:
You can delete the entire sheet that contains the query table and then query will be a "Connection only", If this table is result of power query.
HKFueyAuthor Commented:
Thank you
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.