Excel Online - Compatibility Report - Text Queries


This particular blog is going to handle how to deal with Text queries appearing in the Compatibility Report.

"Compatibility Report
Text Queries
But you can see all the content in this workbook by
Opening the file in Excel."

 

You can fix this several different ways.

1. Edit a Copy, which will remove the unsupported feature.

2. If you know where the Text query is, you can remove the query definition.

3. If you cannot locate the text query, you can use our tool to locate it, and then remove it.

1. Edit a Copy, which will remove the unsupported feature.

You will be prompted "Edit a Copy"

You can then create a Copy.

This will create a clean version of the workbook without any unsupported features.  It will also keep the Original workbook in the event the removal of these features broke your workbook.

2. If you know where the Text query is, you can remove the query definition.

You can right click on the table and untick Query definition > Save query definition under External Data Range Properties.

You can click a cell in the data range > Data tab > Properties > untick Save query definition


3. If you cannot locate the text query, you can use our tool to locate it, and then remove it.

Run the attached add-in (simply double click ListQT.xlam when your bad workbook is open).  You will now see a List Query Tables tab.  You can then choose the List QueryTables chunk and this will show you the Query Table sheet and range.   You can either delete it from the add-in or browse the locate and follow the steps in #2.

 

[View:~/cfs-file.ashx/__key/communityserver-blogs-components-weblogfiles/00-00-01-03-93/ListQT.zip:550:0]

Disclaimer: this add-in is provided to you as courtesy and is "as-is".  Anytime you are making changes to a workbook, it is recommended to create a backup in case you need to revert your changes.rrrr

 


Comments (0)

Skip to main content