|
Klasyczne typy plików nie są już dostępne od stycznia 2021 r. Możesz przenieść swoje klasyczne pliki lub pobrać plik PDF. Dowiedz się więcej

Data load to locked cell

Udzielono odpowiedzi
Zamów wersję demonstracyjną
We have some locked cells in our worksheet that were intentionally locked because we do not want data to load into those cells.  However, we had some cells that were mistakenly locked.  When the data was updated, those cells did not update because of it being locked.  Can Workiva notify the user that these cells were not updated so that we are able to check those cells?  Is there a quick way to see which cells are locked without having to select the individual cells and viewing the cell properties?
-1

Komentarze

Komentarze: 3

Data Głosy
  • Dan Packer
    If you're using Spreadsheets, then open your section, and then hit Alt + ~ to get the overlay to appear.  You'll notice that the locked cells are a different colour than those that are unlocked.  This is the quick and easy way to see which cells are locked and which aren't.

    We use this for cell history too if you select "Authorship" from the drop down then you can see who edited what cell.
    0
  • Isabella Ho
    Thanks Dan!  Would you happen to know if there is a similar function in Presentations?  Using the overlay feature to see the authorship would be useful in Presentations as well to quickly see who may have modified the presentation.
    0
  • Dan Packer
    I don't think this is available in presentations.  The only way I know is to look at revision history to see who modified the section last.  
    0

Zaloguj się, aby dodać komentarz.