Shared Excel Spreadsheet - Microsoft Community

we have shared excel spreadsheet on onedrive. particular spreadsheet has 4 worksheets. share spreadsheet give them access 2 of worksheets , no access other 2.

possible?

hi mark,

 

we'd explain not feasible share 2 worksheets of excel workbook containing 4 worksheet in onedrive business.

 

given situation, welcome , encourage submit feedback uservoice.

this best way perfect our products , service.

thanks understanding.

 

as workarounds, may try create new excel workbook, put 2 worksheets want share others. , share new workbook others.

 

or in original workbook, hide 2 worksheets(right click workbook>choose hide)which don't want give access others, share workbook others no edit permission. (unselect allow editing> apply>get link view permission.)

for reference:

regards,

tina

Office / OneDrive for Business / Windows 10 / Office 365 for business