•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Adding lines to table in protected sheet (Excel 2016)
Our take
Are you struggling to add lines to a table in a protected Excel 2016 sheet? You're not alone. Many users face this challenge, especially when collaborating with Excel novices while keeping essential data secure. While you’ve allowed row additions in the sheet protection settings, it can be frustrating when it doesn't work as expected. In this guide, we’ll explore a straightforward solution that enables your team to effortlessly add deliveries while maintaining the integrity of your project sheet.
Quick disclaimer: My company still uses 2016, so can't benefit from any fancy 365 features.
I have made a sheet to keep track of deliveries in a project. The sheet needs to be accesible to quite a few people, many of which are excel novices and thus needs to be protected.
I would like people to be able to add deliveres (extra rows) to the table, but this doesn't work, even though I've allowed adding rows in defining the sheet protection. Is there a way to do this?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Inserting new, whilst copying adjacent protected formulasDisclaimer! My Excel knowledge is intermediate at best! I’ve made a large workbook that my company wants me to share with colleagues as a standardised template (heavily formatted, not tabled). In order to prevent mistakes they’ve asked me to protect the workbook formulas whilst also maintaining the ability to keep functionality of adding more rows / columns. I’m having difficulty providing both. Example whilst the sheet is protected I can add a new row but it will not copy the previous formula (in my case, it’s a sequential reference to another sheet). I.e. Sheet1!A1, Sheet1!A2, etc. Very basic worked example: Cells A1:B10 are editable cells using edit ranges. Cells C1:C10 let’s say contain a basic formula =A*B. The sheet is protected but allows the inserting, formatting and deletion of rows / columns. I insert a row above row 10 the formula isn’t copied. I copy row 9 and insert above row 10 the protected sheet prevents me from doing this. Might just be me but I can’t see a way how this is possible without the use of Macros which I don’t want to do! submitted by /u/MrMC3113 [link] [comments]
- New cells added to a protected sheet will not lockI created a worksheet that required me to lock certain cells. The worksheet needed editing so I removed the protection so I could add additional columns. One of the two columns needs to be protected, while the other needs to be unlocked for data input. I made the unlocked range in the mange protection window and resumed protection on the worksheet but all new columns remained unlocked. All original cells on the worksheet (before the new colums) still lock and those that were put in an unlocked range remain unlocked. I am predominately working in the browser mode. I have used the desktop app to make sure all cells are locked in the fromat cells > protection settings. In the Manage Protection settings under options "Select locked celld" and "Select unlocked cells" are checked, everything else is unchecked. submitted by /u/middleCHILD-problems [link] [comments]