I was wondering if anyone is familiar with the Team Consolidation feature in Lotus 123. I have a Notesdatabase set up and the Spreadsheet alresdy created. My question is, can you lock cetain cells and still use the consolidation feature.
This workbook contains 24 spreadsheets that are distributed to 24 different people. Thses 24 spreadsheets are the rolled up into a single Master spreadsheet. Problem is I have some people who insist on making changes where they should not and it completely mess's up my formulas.
I would like to protect certain sections so that they can not make changes in those areas.
Any assistance would be greatly appreciated.