Forum Discussion
Problem with "Copy link to this sheet"
I want to use the Excel web app's "Copy link to this sheet" feature to give another user access to just one sheet from my workbook. But the resulting link lets the user see the entire workbook. How do I correct this?
I am also experiencing the same issue. I follow the same steps but when someone opens the link, not only do they see everything, but they also have the ability to edit the workbook, which I changed to view only. I am using Excel web version as well.
I see that this hasn't been answered so I wanted to add on and hopefully resolve this issue.Try this:
- Open the Excel Web App: Go to the Excel file stored in OneDrive or SharePoint.
- Select the Sheet: Click on the sheet tab you want to share.
- Copy the Link: Right-click on the sheet tab and select "Copy link to this sheet".
- Adjust Sharing Settings: When the link is copied, a message will appear. Click on the "Close" button.
Yes, that is what I am doing to create the link. The problem is that anyone who follows the resulting link sees the entire workbook with all of its sheets, not just the one sheet I requested the link for. Maybe I'm just misunderstanding what "Copy link to this sheet" is supposed to mean?
I have same proble for my bowling league. I wanted one tab for each team on my bowling league, giving an edit link to one sheet per team captain so no team captain could enter or change scores for anyone except their own team.
I ended moving each sheet to a separate spreadsheet, with many identical small spreadsheets, one per team with a link for each going to one team captain each, and the master sheet using workbook links that have to be continuously refreshed from the other linked spreadsheets. It's a pain!!!
