May 15 2018 04:12 PM
I am trying to convert a Table to a normal range. I right click on the table and choose "Table>Convert to Range" . After selecting "yes" the data remains unchanged in a Table format. Are there any other checks I can take?
May 15 2018 09:20 PM
May 30 2019 09:05 PM
@Clinton AzoteaI had the same problem with a couple of Excel tables. I would click Convert to Range and then click Yes, I do want to convert the table to a Normal Range, and nothing would happen. The only workaround I could find was to copy and paste as Values with Number Formatting.
The problem seems to reside in certain Excel workbook files. If I copy the Excel table to a new workbook, I can convert the table to a range without any problem.
Nov 07 2019 10:56 AM
I can confirm this is still an issue in Version 1902.
Nov 07 2019 11:41 AM
Nov 21 2019 09:54 AM - edited Nov 21 2019 09:56 AM
@Jon Peltier it appears it continues to behave as a Table - I tried for example deleting the headers, but they keep getting automatically renamed to "Column1" or "Column3" or whatever the value would be assigned by an actual table.
One thing to mention is that my table used to be connected to an external data source, which I'm removing in order to link it to a different external data source.
Nov 21 2019 12:28 PM
If you have any data connection, even for deleted source, you can't convert the table. All connections are to be removed first.
Mar 29 2021 08:36 AM - edited Mar 29 2021 08:37 AM
I had a similar issue. What I found was that you need to first perform some Table action. Then you can successfully convert the Table into a Range.
Example: I first sort the table. Then I am able to successfully convert it.
May 21 2021 06:16 PM
I had to copy the sheet (w/o the table headings) to a new workbook, delete the table sheet, and recopy the sheet back to the original workbook.
May 23 2021 05:02 PM