Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Formulas linked to sheets which are restricted



1 comment

  • Jamie

    When you say restricted, I assume you mean no access to even view the sheet? I actually think I would prefer that the formula is corrupted in this case. Otherwise what would prevent someone who shouldn't have access to view the sheet contents changing a formula to include something they shouldn't see? I understand your situation is just rounding, but what if someone could update a formula to include restricted data? I think that defeats the purpose of restricting access the sheet. If you change their permissions to view only, does this still corrupt the formula?


Please sign in to leave a comment.