The Next Big Thing in Excellentable: Cell/Sheet protect

When you have multiple people with access to the same confluence page, there will be a time when someone inadvertently edits something. And this starts a whole process of tracing logs, checking version history and comparisons. 

The whole thing is even messier if the inadvertent change happens in a table, where small changes in variables can result in incorrect numbers and reports, creating a lot of bewildered users. This becomes even more serious when we have large datasheets with a lot of linkages, where even a small changes can creates large issues, which are difficult to triage.

Cell/Sheet Protect

Excellentable has introduced Cell Protect/Sheet Protect feature to avoid similar errors in the future.

Consider the case below: I want my regional sales team to be able to report their numbers, so i have created a collaborative editable spreadsheet in Confluence. The idea is simple, the regionwise sales team will enter the data, and i will report out the totals.

However, i do not want the sales team to edit the green Highlighted Sections, as they not only contain the highly complex "Sum" formulas, but they are also watched by my everyone in the floor including my managers.

To avoid this, i will protect the Cells (Just select cells to be protected→ right click →  Protect Cells)

Now anyone trying to edit the selected cells will get the following message

Once the sales team have entered the numbers, i can even protect the whole sheet. This will stop any further edits to the sheet (Just select sheets to be protected→ Right click →  Protect Cells).

We hope this makes your Confluence Tables a bit better and efficacious. For Further reading, please go through our user guide

Excellentable is trusted by Samsung, Coca Cola, Marvel Studios, US Dept. of Defense, Dell, Charter Communications and many more customers.

Related Content
The Perfect Match: Confluence & Excellentable
Discover the perfect match for your team's collaboration needs this Valentine's Day. Learn how to seamlessly...
Confluence template
Streamline Root Cause Analysis in Confluence with RCA Template
Explore the benefits of using the Confluence RCA template to streamline root cause analysis, improve...
Excellentable collaborative editing
Supercharge Confluence Tables: Split Cell, Formatting, Formulas and more with Excellentable
With Excellentable you can unlock the Power of Spreadsheets in Confluence tables, Split Cells, Advanced...

Leave a Reply

Your email address will not be published. Required fields are marked *