Forum Discussion

kartikgiriyappanavar's avatar
kartikgiriyappanavar
Copper Contributor
Aug 13, 2024

Freezing Pane Protection Requirement Shared Drive

Hi all,

 

Current Situation:

I am currently working with a team collaboratively on an Excel sheet. The creator of the shared file has set and communicated a standard freeze pane on a particular column & row.

 

Issue:
Since it is a shared file on OneDrive, there are instances where users are tampering with the freeze panes that have been communicated to stay as is. This causes formatting errors, hence affecting the whole data set as a whole.

 

Query:

Is there a way to protect the file as such that cells can be updated (input can be added), BUT the freeze panes set should stay permanently where no one can format this.

I have tried locking cells with the sheet protection, however I still can unfreeze and freeze panes still.

1 Reply

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor

    kartikgiriyappanavar If the files are being edited using desktop Excel, you can consider using ribbonX code to disable the freeze panes button. If they are edited in the browser, well, I don't know!