I have created an excel template with few tables.Added few data validations and conditional formatting.This excel template is placed on our server without any data in our tables present in the excel.However once a user clicks on download template option the data in those tables is populated from our backend database.The issue is when the user opens the excel sheet.It gives a warning->We found a problem with some content in filename.xlsx.Do you want us to recover as much as we can.When I click ok to recover it then shows me->
1)Removed feature autofilter from table1.xml. 2)Removed feature table1.xml
3)Removed feature: Autofilter from table2.xml.
1)My query is when does excel try to recover a table and when does it consider a table to be corrupted and that it would need a repair and why does it remove autofilter?I have several tables but this repair is happening for only 2 tables i.e table1 and table2, out of which there is no table named table 2 which is my 2nd concern.What do I need to do to avoid this repair?
2)And my 2nd question concern is->
I dont have any table with name table2.So where did it find table2.xml? I have a table named "table1" and that table is removed as part of repair but there is no such table named table2.I have other tables but their names are custom names.
Any help on this is would be really helpful.Thank you.
