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 ...
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.
