Forum Discussion
Sharing a single tab only
NikolinoDE I have a user that keeps referencing this info from MS. https://support.microsoft.com/en-us/office/share-a-section-of-a-workbook-dd5d3385-a8f7-4a25-9283-ff505ad8ddb4#:~:text=First%2C%20you%20create%20a%20link%20to%20the%20shared,can%20simultaneously%20view%20or%20edit%20the%20workbook%20section. I've tried various different ways and the results are always the same. The entire workbook is shared. Am I missing something?
Sharing the link on the range/sheet as in reference we only notify user the user with which object in Excel to work - Excel gives focus on it and highlights it. Perhaps we may play with permissions on shared range and the rest, didn't test. But in any case entire workbook will be opened.
And in Excel for web we can't copy the sheet to another file.