Skip to content
All guides

Business tools

One Worksheet, Mixed Participants: Google Drive or OneDrive Link?

A shared exercise worksheet is where workshop participants actually work. Whether it lives in Google Drive or OneDrive decides who can edit without an account, whether edits carry names, and whether the link can expire.

Contents

The worksheet is where participants actually work

In many remote workshops the slides are watched and the worksheet is used: groups fill in a table, draft a paragraph or rank options in one shared document. If half the room cannot edit it in the first minute, the exercise stalls, and the facilitator spends the time on links instead of content.

When participants arrive with a mix of Google accounts, Microsoft accounts and no account at all, the account that owns the worksheet matters more than the editor itself. Google Drive and OneDrive treat link sharing differently, and the difference decides which owner fits.

How Google Drive link editing behaves

Google's help says a file with general access set to anyone with the link can be used by anyone who has the link without signing in to a Google Account, with the role you choose: viewer, commenter or editor. People who are not signed in show up as anonymous animals in the file.

For a quick group exercise that is convenient, because no one needs an account to type. The cost is attribution: an anonymous animal cannot be matched to a participant afterwards. Google also notes that expiration dates for access are only available for eligible work or school accounts, so on a personal account the link stays open until you change it.

Two habits make anonymous editing workable. Put the instructions in the worksheet's first rows, so nobody has to ask where to type, and keep a clean copy of the worksheet in the owner account, so a row deleted by mistake can be restored from it after the session.

How OneDrive Anyone links behave

Microsoft's OneDrive help describes Anyone links as giving access to whoever receives the link, including people it is forwarded to. With editing allowed, people who are signed in with a Microsoft account can edit; without editing, people can view, copy or download without signing in. Allow editing is on by default, so check it before sending.

OneDrive adds two controls on the link itself: an expiration date and a password. Microsoft says both are only available to Microsoft 365 subscribers, and on work or school accounts administrators may restrict the sharing options you see. Because Anyone links also work for forwarded copies, the password is what keeps a forwarded link from opening the worksheet for someone outside the session.

A twenty-person session, worked through

Hypothetical: a facilitator runs a planning workshop for 20 volunteers from three organizations. About half have Microsoft work accounts, some use personal Gmail, and a few have no account they are willing to use. The exercise is a shared table where each group fills in two rows.

Option one is a worksheet owned by a workshop Google account and shared as anyone with the link can edit. Everyone types within a minute, and the facilitator asks each group to write its group number in the first column, since signed-out editors appear only as anonymous animals. After the session the link is switched to view only.

Option two is a worksheet owned by a Microsoft account with a Microsoft 365 subscription, shared as an Anyone link with editing, an expiry at the end of the week and a password read out in the session. Editing requires a Microsoft sign-in, which the people without an account cannot do, so they dictate to a group member. The facilitator chooses option one for this group and keeps option two for a later client workshop where every participant has a Microsoft work account and edits must carry names.

Fit and not-fit for each owner

A Google-owned worksheet fits when participants without accounts must edit and anonymous edits are acceptable. A Microsoft-owned worksheet fits when edits must be attributable to signed-in people, or when the link should expire or need a password, provided the owner has a Microsoft 365 subscription.

Neither fits well when the worksheet would hold personal details about participants. Collect those in a form with restricted access instead, and keep the worksheet for the exercise itself.

Keep the worksheet out of personal storage

Whichever route you choose, let a dedicated workshop account own the worksheet rather than a facilitator's personal login, so personal files and the participants' working document never share one Drive or OneDrive. The workshop account can also hold the template copy you duplicate for each new group.

Google's terms make you responsible for what you do with your Google Account, and Microsoft's Services Agreement says Microsoft account credentials cannot be transferred to another user. Keep the owner account with the person who runs the workshops and share the worksheet itself, not the login.

Choosing the owner account on rStock

rStock is an independent marketplace and is not affiliated with Google or Microsoft. In Google listings, look at the address and how recovery details are handed over; in Microsoft listings, look at whether a Microsoft 365 subscription is described, because the expiring-link route depends on it.

Pay from your rStock balance and test the worksheet link from a signed-out browser as soon as the delivery record appears on your order page, while the window shown there is open. Then compare the Google or Microsoft accounts that match the route your participants need.

Frequently asked questions: One Worksheet, Mixed Participants: Google Drive or OneDrive Link?

Keep reading