I want to integrate two planning queries with disjoint sets of data into one workbook (different sheets). How is the data locking working in that case.
If I open sheet one, is only data set one locked by the user or both? Ideally, I want to let several users work in the same workbook at the same time in different sheets. Is this possible?
I have system currently to check it out by myself.