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
Confluence template
Streamlining Employee Performance Reports in Confluence
Learn how to efficiently manage employee performance reports in Confluence by take advantage of Excellentable...
Excellentable collaborative editing
Unleash the Power of Tables in Confluence with Excellentable
Excellentable transforms tables in Confluence, with unique view mode features like sharing searches,...
work from anywhere
Embracing the Freedom: Work from anywhere
If our products can be used from anywhere, we should also be able to work from anywhere. This blog shows...

Leave a Reply

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