Not so much a question, as I wanted to document this for the greater good -- couldn't find it elsewhere anywhere.
Case:
I have several tables in a file acting as datasources for PowerPivot. After using it for several weeks, I got this error on opening that Excel found a problem with some content. After agreeing, it gave me the message "removed feature: autofilter from /xl/tables/table1.xml part (table)" and "removed feature: table from /xl/tables/"
The table remained, but the connection to PowerPivot was broken. Haven't been able to figure out how to rebuild a connection - so tried deleting and building it again from scratch -- no success -- next time I opened the file, *all connections* were broken with anothe repair operation.
Looking at the original broken table - it's copy/pasted from a regular email - I noticed a merged-cell row at the bottom that I normally delete, but had forgotten about. However, couldn't open the file without Excel going through it's "repair" operation.
Then I remember that an .xlsx, in the background, is just a compressed group of plain text xml files.
Using 7-zip, I 'opened inside' the .xlsx file, navigated to the worksheet with the table on it, found and deleted the row reference with the merged cells. Saved.
Excel opened the file perfectly - hours of work saved.
Case:
I have several tables in a file acting as datasources for PowerPivot. After using it for several weeks, I got this error on opening that Excel found a problem with some content. After agreeing, it gave me the message "removed feature: autofilter from /xl/tables/table1.xml part (table)" and "removed feature: table from /xl/tables/"
The table remained, but the connection to PowerPivot was broken. Haven't been able to figure out how to rebuild a connection - so tried deleting and building it again from scratch -- no success -- next time I opened the file, *all connections* were broken with anothe repair operation.
Looking at the original broken table - it's copy/pasted from a regular email - I noticed a merged-cell row at the bottom that I normally delete, but had forgotten about. However, couldn't open the file without Excel going through it's "repair" operation.
Then I remember that an .xlsx, in the background, is just a compressed group of plain text xml files.
Using 7-zip, I 'opened inside' the .xlsx file, navigated to the worksheet with the table on it, found and deleted the row reference with the merged cells. Saved.
Excel opened the file perfectly - hours of work saved.
