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 ...
Is it still really a Table, or does it just still have the colors applied without the filter buttons and other table features?
JonPeltierMVP 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.
If you have any data connection, even for deleted source, you can't convert the table. All connections are to be removed first.
