Excel table not expanding with new data

[1021557]

Hi, I created a table in Excel that was working perfectly for other users to enter data. Now it is no longer expanding automatically when new data is entered in the next available row. I have tried everything including checking the auto format as you type in options (it's Excel 2010). I had the sheet protected and when I unprotected it new rows do seem to form part of the table. I have unlocked the cells below and checked allow 'Insert rows' option when it's protected. Any ideas on how to keep the sheet protected while allowing the table functionality to work when new data is entered?

Thanks

Mike

 

[Zack Barresse]

Hello,

This is a shortcoming of Tables on a protected sheet. The only real way around this is to use a change event with VBA to unprotect the sheet, extend the Table range, then re-protect the sheet. It's very messy. To get rows to insert you would need to have it on an unprotected sheet.

 

[1021557]

Hello,

This is a shortcoming of Tables on a protected sheet. The only real way around this is to use a change event with VBA to unprotect the sheet, extend the Table range, then re-protect the sheet. It's very messy. To get rows to insert you would need to have it on an unprotected sheet.

OK, thanks very much for letting me know.