Hyperlinks to Password Protected Documents in One Drive

We have a shared One Drive account and I would like to create a hyperlink to certain documents that are password protected to certain users of a Smartsheet. Is it possible to do this so only those with a password can open the documents (either in Excel or PowerPoint)?

Find more posts tagged with

Sales

Sharing and Collaboration

Security

Comments

Mike L.

I'm not using onedrive but I think this may be similar. I have put a hyperlink on a dashboard to an excel document saved to box.com. When I click on the file it opens in the box.com (web interface) as view only. From there I can open it in Excel online or using the desktop installed excel (after boxtools is installed). If I want to password protect the file I would do it in excel not in smartsheet. I believe the same can also be accomplished using the attachments field in any sheet.

tracey.p63831

I have added a password but the other users cannot open the document. They get an error message to say the file is encrypted and no option to open it in the online Excel or PowerPoint as I do.

Marcus Odum

Similar to Mike's response. If you are using OneDrive my suggestion is to use the permission structure inherent to OneDrive rather than locking an Excel file. I use it constantly without issue. Smartsheet has built in OneDrive support.

https://www.smartsheet.com/apps/onedrive

Locking fields and sheets are a separate issue.

Sign in to join the conversation!

Quick Links

Trending discussions

Viewers and Permissions after new pricing model
I have provisional users who, under the legacy model, were unlicensed users with editing permissions for workspaces. I’ve now changed their role to "viewers" and assigned editing permissions to specific workspaces, aiming to maintain the same editing experience as before. However, they cannot edit fields within tasks or…
Delete inactive smartsheet account
I'm trying to figure out how to delete an inactive Smartsheet account so I can use that email address for another account. The account I'm trying to delete was a free account with no system admin, so there's no one to contact. The AI bot with the Help Center told me my only option was to use the Smartsheet Community. Any…
Phone number validation won't allow all zeros
Hi- We have been using a SmartSheet Form for a while, and users have been able to enter 000-000-0000 if they don't know a person's phone number. However, over the past few days, it appears that the phone number validation field will not allow all zeros any more. Is there a way that I can change this? We would like the…