hi all.
I have a central 'leads' excel sheet, that is stored on our onedrive.
Person A through person D have access to it.
I have another sheet "Output.xls" stored in the same location, where person E can access / see it, but not edit.
output.xls is pretty much a selected data transfer from the leads excel sheet ( =[Lead Sheet.xlsm]Output'!E9 )
My question is, because Person D doesn't have access to Leads sheet, will the data update when they open Output.xls?
thanks
I have a central 'leads' excel sheet, that is stored on our onedrive.
Person A through person D have access to it.
I have another sheet "Output.xls" stored in the same location, where person E can access / see it, but not edit.
output.xls is pretty much a selected data transfer from the leads excel sheet ( =[Lead Sheet.xlsm]Output'!E9 )
My question is, because Person D doesn't have access to Leads sheet, will the data update when they open Output.xls?
thanks