excel data tables

Occasional Visitor

I have a data table inside a Worksheet.  The worksheet is protected, but the lines for the data are unprotected.  When I start the first data table entry all is ok fine.  When I go back to the worksheet to enter more data, I am unable to add new data.  I click on NEW button it will not allow me to add  new data.  If unprotect the worksheet I can add new data to the worksheet.  What do I have to doData table template to be able to have a protected worksheet, but still be able to enter data into the data table template?

0 Replies