+ Reply to Thread
Results 1 to 3 of 3

Google Sheets and sheet protection exceptions

  1. #1
    Registered User
    Join Date
    08-23-2014
    Location
    Cape Town, South Africa
    MS-Off Ver
    2019
    Posts
    19

    Google Sheets and sheet protection exceptions

    Hi

    I need to protect a Google sheet and there are a large number of cells that need exceptions.

    Is there an upper limit on the number of cells that can have exceptions?

    In this sheet I can't seem to be able to except AI8:AL107

    I can include it, the exception seems to be accepted, however when I do so I can't edit those cells from another account.

    Also the total number of exceptions (145) does not increase in number. This is why I'm suspecting an upper limit for exceptions.

    When I create a copy of the sheet and remove all exceptions except for AI8:AL107, the exception works.

    Unmerging: I've tried unmerging the cells to see if that is the issue, however that does not help.

  2. #2
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,066

    Re: Google Sheets and sheet protection exceptions

    Have you got it set that only you can edit the range?
    As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.

    And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]

  3. #3
    Registered User
    Join Date
    08-23-2014
    Location
    Cape Town, South Africa
    MS-Off Ver
    2019
    Posts
    19

    Re: Google Sheets and sheet protection exceptions

    Hi

    Apologies for the very slow response, I found the notification in my spam folder.

    "Have you got it set that only you can edit the range?"

    Yes, I have.

    Eventually the problem resolved itself. I think it had something to do with Sheets not updating changes correctly. At work the internet connection is very problematic and this may have caused the updating issue.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Google Sheets: Condition formatting in Google sheet
    By cyee in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 02-18-2021, 05:35 PM
  2. Excel Protection
    By Mahmoudelnemr in forum Excel General
    Replies: 9
    Last Post: 04-15-2020, 03:30 AM
  3. Google Apps Script for Google Sheets Pulling Formulas from Master to Several Slave Sheets
    By excelroofing in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 08-22-2018, 02:06 AM
  4. Comparing Multiple Columns on 2 sheets and report Exceptions on 3rd Sheet
    By KrystalQ in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-24-2014, 11:41 AM
  5. Why aren't the exceptions I selected in WS Protection working?
    By valverax in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-13-2005, 04:20 PM
  6. [SOLVED] Protection-exceptions to delete a row
    By Frederic in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-12-2005, 06:05 AM
  7. [SOLVED] Worksheet protection with exceptions
    By KG in forum Excel General
    Replies: 3
    Last Post: 02-09-2005, 03:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1