Forum Discussion
Office 365 Excel stopped auto-expanding a table
I've done some searching, but traditional fixes like checking the options (O365 doesn't have those), clearing data under the table, and creating a macro (I shouldn't need to do this to fix what I did...
You're sure the option to auto-expand tables is checked (File, Options, Proofing tab, Autocorrect button, "Apply as you work", "Include new rows and columns in table" check box)?
I tried this and it was checked but still not adding new rows automatically. It would add columns, but not rows, which told me something else was preventing the rows from getting added. Turns out if you you check the "Total Row" feature (Table Design toolbar > Table Style Options) of a table, add anything to that total row, then uncheck the "Total Row" feature to hide it, it will still prevent a new row from being added to the table, even though the Total Row is hidden.
When I checked the "Total Row" to show it, deleted all my content in the Total Row, then hid the Total Row again, the Table then started automatically creating new rows when text was entered immediately below the table.
- Sounds like a bug to me. Perhaps you can click Help, Feedback, I don't like something and tell them so?