• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 44
  • Last Modified:

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?
0
HKFuey
Asked:
HKFuey
  • 2
  • 2
2 Solutions
 
jkpieterseCommented:
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?
0
 
HKFueyAuthor Commented:
Creating a formula based on table results in a long and often un-decipherable string!
0
 
abbas abdullaCommented:
Hi,
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.
0
 
jkpieterseCommented:
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.
0
 
HKFueyAuthor Commented:
Thank you
0
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.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now