Hello,
does anyone know if it is possible to share different Worksheets from within an Excel Workbook with different users?
For example share sheet 1 with user1 and share sheet 2 with user2.
Frank
Share different Worksheets with different users in an Excel Workbook
hi frank,
to share a specific worksheet, you can use the following workaround:
1. right-click on the tab of the worksheet you want to share. if you want to share more than one worksheet, hold down the ctrl key & click each one.
2. click on move or copy.
3. in the to book: select (new book) and check the create a copy. click ok.
the worksheet/s will now be opened in a separate workbook with a default name, like book1.
4. in this workbook, click on file > share > email > send as attachment.
moreover, as this is a client usability quire, if you have further questions, we suggest posting to the technet forum where engineers are experts in this field.
your understanding is appreciated.
spike