Share only one sheet in Excel stored in Onedrive?

[gotido]

Can i share only one sheet in Excel stored in Onedrive, instead of the entire Workbook?

Thanks

 

[jkpieterse]

Depends. Do users need to edit the sheet, or is this just a calc sheet and can their entries be discarded once they close it?

 

[gotido]

Depends. Do users need to edit the sheet, or is this just a calc sheet and can their entries be discarded once they close it?

They need to edit the sheet.

its a sales report and i´d like to give a link to a specific sales consultant

 

[JEC]

You can't share just one sheet and still have it connected to the original file. What you can do is write a macro which will prevent navigating to other sheets.
But, that will only work on desktop versions. It doesn't in online Excel versions.

 

[Joe4]

How about just protecting the sheets that you don't want updated, so they cannot be edited?

 

[JEC]

Or hide the sheets that you don’t want to be edited or seen. Then protect the workbook instead of sheets

 

[jkpieterse]

Give each sales reps their own file and bring in the data from all files using data, get data, from file, from folder