View Single Post
 
Old 06-22-2011, 05:39 AM
beb1227 beb1227 is offline Windows XP Office 2007
Novice
 
Join Date: May 2011
Posts: 18
beb1227 is on a distinguished road
Exclamation Issue with a Shared Excell Doc.

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
Reply With Quote