Office 365 Excel stopped auto-expanding a table

[wilsonbps]

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.

[#2]

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)?

[#3]

@JKPieterseThat option does not exist on Excel for web. I will open it on the desktop editor and see if that is enabled

[#4]

It is enabled on the desktop editor and works as expected.

[#5]

@wilsonbps Given that I was unable to find any relevant hits when googling for this issue I suggest you open the workbook in question in your browser and click the "Give feedback to Microsoft" link (bottom-right corner of the window) and then click I don't like something button. It will send some diagnostics data to MSFT along with your comment.

[#6]

I'm having this same issue and its driving me batty. Did you ever find a solution?

[#7]

@Jules6598I just stopped using the web version. It's quicker that way

[#8]

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.

[#9]

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?

[#10]

@JKPieterse Thanks for the tip. I've never noticed the widget, but it's a possibility. I'll look out for it. 

[#11]

@JKPieterse 

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.

[#12]

Sounds like a bug to me. Perhaps you can click Help, Feedback, I don't like something and tell them so?