Forum Discussion
Table will not convert to range
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 ...
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.
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.
