Jan 07 2021 04:43 AM
Hi to all and happy new year
I have one excel workbook with 10 different sheets, i want to share with 10 different people and i want each one to have access to one different sheet, is that possible?
thanx in advance
Jan 07 2021 05:04 AM
I'd copy each sheet to a new workbook, and share that.
Jan 07 2021 05:26 AM
This is i do today i want to have one workbook not 10 different @Hans Vogelaar
Jan 07 2021 05:39 AM
Afraid that's not possible. You may protect regions to allow users edit the data based on account, but not to hide the data. In general, security in Excel is not to hide the data, it's more the way to avoid mistakes due to negligence.