<div>
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.<br />
Why are you asking?
</div>


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?

<div>
Creating a formula based on table results in a long and often un-decipherable string!
</div>


Creating a formula based on table results in a long and often un-decipherable string!

<div>
<div class="content wysiwyg-content">
Does anyone know how to remove a table format from Excel 2016/365 but keep the data query behind it?
</div>
</div>


Does anyone know how to remove a table format from Excel 2016/365 but keep the data query behind it?

Excel remove table, Keep data query

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.