Can Tables work on a protected sheet?

[Monsignor]

I'm working with a table so that formulae copy with each new entry. But when I protect the sheet, the table quits working. Is there a solution for this?

 

[Jerry Sullivan]

This article by Jan Karel Pieterse and its follow up comments address limitations of using Tables on Protected Sheets.

http://www.jkp-ads.com/Articles/Excel2007Tables.asp

 

[Monsignor]

JS411, thanks.

I read through, got a lot out of it. Looks like tables and sheet protection aren't friends.