If I allow a sheet to be view only to the public, is there any way to limit the copying of the data? I noticed a view only user can copy the workbook, which I assume means the data as well which I don’t want. I know they can do a screenshot, but I would like a true view-only view for a public user.
There is currently no way to prevent users from copying and pasting data with the keyboard, however, in publicly shared workbooks there is a way to disable the ability for users to copy the workbook. Steps:
Click the Share button and choose Public sharing and embedding
… or navigate to File > Public share and embed …
… then make sure the Allow users to copy this workbook checkbox is unchecked, as shown here:
View sharing and embedding is now available as of our Feb 18th release.
Details here: Product Updates - February 18, 2023 - Share Views and Charts Enhancements
Help Center content here: