Really could use some help if anyone knows much about this.
We have a document that is shared by at least 4 people. I have locked some of the key cells, that I do not want to be edited. cells below say row 10 are to be updated to show the dates that items are received....from left to right.
we have a title row in row 9....and the typical setup is for the sheet to freez just below the title row.
Based on the size of the document...or something this freeze keeps locking up and not working. When I share and protect the doc though, it removes the ability for me or any of the others to do anything with Freeze.
I would like to know if there is a way so that I can either stop this Freeze from locking up while in Shared and Protect.....or if I can some how set it so that all of us have the ability to Unfreeze and then Freeze.....since that is how it is usually fixed in unshared format.
Thanks