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.

​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.  Read More

​