Locking data in spreadsheets to avoid editing
UkończoneI am trying to prevent any editing to a spreadsheet that is linked to a filed document. In Classic, there is an option to freeze all filed documents, but I can't seem to find anything in next gen. I see that there is something called "locked" for cells, but again, can't easily find instructions. Searching in the community is a bit hit and miss, so I'm sorry if this has been asked before.
-
Oficjalny komentarz
A little late to the game, but the good news is that Lock Edits has been made available in Workiva.
Hi Barbara the quickest way I found to restrict access was through the use of spreadsheet permissions.
Locked cells seemed to only locks the cell contents for editing as I noticed that I could still add rows and columns to a sheet even though it was locked.
At least only owners of the spreadsheet can unlock locked cells.
Another item that could be useful in conjunction with locking is to switch on track changes.
0
The ability to freeze and thaw in next gen is not yet available. The alternative is to change permissions on the documents to view only. Depending on if you have different permissions for sections you may need to use the advanced editor to update all sections. Freeze/thaw is supposed to be released as an update by the end of the year, but that timeline keeps changing. I'm not positive, but I though that any editor could unlock cells.
0
Nailed it @.... Couldn't have said it better myself.
I got you added to the existing request list Barbara. You can follow along, here: https://support.workiva.com/hc/en-us/requests0Zaloguj się, aby dodać komentarz.
Komentarze
Komentarze: 4