Forum Discussion
Solved
Can we share a site with public users using a link
In SharePoint online we can share a file or folder using anonymous links, so users without login can view the file or folder, but can we do the same for a whole site or a whole library? so the site or library can be accessed using a public/anonymous link?
Thanks
This issue with hyperlinks changing after cut and paste in Excel is a known problem and can be frustrating, especially when dealing with large datasets. Here's why it happens and how you can potentially solve it:
Why it happens:
When you cut and paste cells containing hyperlinks, Excel sometimes adjusts the relative paths based on the new location of the pasted cells. This can lead to incorrect links pointing to different pages than intended.
Potential solutions:
1. Paste using Paste Special:
Instead of using the regular "Paste" command, try using "Paste Special" and choose the option "Values and Hyperlinks." This option pastes the cell values and preserves the original hyperlink addresses without any adjustments.
2. Use absolute references:
You can modify your hyperlinks to use absolute references instead of relative ones. Absolute references point to specific locations regardless of the cell's position in the spreadsheet. To create an absolute reference:
- Before the link: Add a dollar sign ($) before both the column and row number in the hyperlink address. For example, instead of https://www.discogs.com/release/1410441-Cure-Wish, use https://www.discogs.com/release/$A$1410441-Cure-Wish.
- Within the link: If the link contains internal references to other cells within your spreadsheet, use absolute references for those cells as well.
3. Use helper columns:
Consider using a separate column to store the absolute hyperlink addresses. This way, you can copy the values from this column and paste them into the hyperlink field without worrying about relative path adjustments.
4. Use VBA macros (advanced users):
If you're comfortable with VBA, you can create a macro that automatically corrects hyperlinks after cut and paste operations. This requires writing code to identify and adjust the links based on specific criteria.
Additional tips:
- Save frequently: This ensures you don't lose significant work if the issue persists and requires manual correction.
- Test your solutions: After implementing any of these methods, test a few links to ensure they work as expected before applying them to your entire dataset.
By trying these solutions, you should be able to minimize the issue of hyperlinks changing after cut and paste in your Excel spreadsheet. Remember, the most suitable approach might depend on your specific workflow and preferences
4 Replies
- No, we cannot share a site with public users using a link. If you want to share a group of people outside you organization, you need to add those users in a security group and share a site with them.
ashikurrahmanso if we add those external users to a security group then we can share the site using anonymous link ? or anonymous links works only for files and folders but not for a whole sit?e
- John John No if you add those external users to a security group then you cannot share the site using anonymous link because don't have option share a site using anonymous link. anonymous links works only for files and folder.
Yes, in SharePoint Online, you can share a site or a library with public users using an anonymous link. This feature allows users without login credentials to access the shared content through a URL link. However, the availability of this feature depends on your SharePoint configuration and the settings established by your organization's administrators.
To share a whole site or library with public users:
- Navigate to the site or library that you want to share.
- Click on the "Share" button or the "Share" option from the menu.
- In the sharing options, choose "Anyone with the link" or a similar option, depending on your SharePoint version.
Note: The exact wording of the option may vary depending on the SharePoint version and configuration.
- After selecting the appropriate sharing option, SharePoint will generate an anonymous link that you can distribute to public users.
Copy and share the generated link with the intended audience.
Keep in mind that sharing content via anonymous links may have security implications, as it allows unrestricted access to the shared content for anyone with the link. Therefore, it's essential to carefully consider the sensitivity of the information you're sharing and ensure that it complies with your organization's security policies.
Additionally, SharePoint's sharing settings can be further customized by administrators to control how long the anonymous link remains active and what actions users can perform with the link (e.g., view-only, edit, download). For more granular control, your organization's SharePoint administrators can set up specific permissions for individual users or groups if necessary.
Always ensure that you are aware of your organization's SharePoint policies and consult with your administrators if you have any concerns or questions about sharing content with anonymous links.
