I have a spreadsheet that I need to lock and have others be able to add rows for data entry. The problem I have is that when adding rows in the locked document, the formulas don't auto-populate
That is one of those things that a protecting a sheet makes harder to do. The simplest solution is a macro tied to a button that unprotects the sheet, inserts a row and protects the sheet
