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 not break) are a no-go.
My shared workbook has a table that has suddenly stopped auto-expanding when adding another row. I'm up to 669 rows. It stopped working at 666, so that's not suspicious at all... Columns A-AZ are populated with extensive formulas on about half of them.
Any ideas? I've dumped like 80 hours into this workbook and really don't want to re-make it.
13 Replies
peteevensYes that setting is cunningly hidden from view, isn't it!
- 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)?
JKPieterseThank you for the tip about the autocorrect option! I would never have found it buried under "Proofing." A table in one of my files suddenly stopped auto-expanding, and sure enough, that never-before-seen option was deselected. Checking the box immediately solved my problem!
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?
- Thank you, that was a setting I'd been desperately looking for and failing to find. As ever it's a mystery how it ever came to be switched off. Up to a couple of days ago it was on, then I suddenly lost the feature.
- When you add something to a table, a small popup icon shows which allows you to turn that off. This widget can be activated using (I think) pressing the control key. Maybe this was turned off that way by accident?
