Hi,

Say i export a whole month of accounting transactions to microsoft excel and use pivot table to sort out those data by putting cost centres in page field. Then i send the data to all cost centre owners with only their cost centre transactions shown in data field. My query is: since i use page field to filter the cost centres, is there a way to block other cost centres data in page field, so that the cost centre owners cannot view other cost centres data?

Or is there a better way to go about it?

Thanks for the input in advance.