Forum Discussion
kerl1971
Mar 04, 2024Copper Contributor
Excel Convert to Range Not Working
I'm trying to disable table functionality in a spreadsheet. It's pretty extensive. So, I do not what to have to delete everything and start over. I've tried the Table Design>Tools>Convert to Range, but nothing changed. The data still exists as a table. What other options do I have to correct this?
Texas_Technician Check these links:
- Complete basic operations using SharePoint REST endpoints
- Work with lists and list items
- Work with folders and files
- REST API reference and samples - I think this is what you need. From this link, you can find more documentations in left navigation:
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
3 Replies
Sort By
- kerl1971Copper ContributorI may have found a work around. I copied the table and pasted the formulas on a different worksheet and deleted the corrupted table. That seems to have fixed the issue.
Thanks! - JKPieterseSilver ContributorWhen you convert a range to a table, the formatting is left behind. But the "table" is no longer a "table" (which you can prove by inserting a row in its middle and you'll see the alternate shading is now "off").
- kerl1971Copper ContributorThanks, Jan. However, that is not what I'm seeing. Even after choosing Convert to Range the table is retaining it's table features, not just the formatting. I did as you suggested and inserted a new row and the alternate shading is visible. Additionally, the filter drop down arrows are still in the header row. I'm getting no error messages. I click "yes", the dialogue box goes away, but the table remains unchanged.