Set Up Worksheets
- Steps: Set Up Security for Drive and give all Worksheets users access.
- Security:Security Configurationdomain in the System functional area.
You might need to take additional steps to enable this feature based on your organization's subscription service agreement. Your organization is either on the Main Service Agreement (MSA) or the Universal Main Service Agreement (UMSA). To determine your organization's subscription service agreement:
- Select your profile avatar on Workday Community.
- SelectProfile.
- On your profile page, select your organization's name, which is beneath your name and next to your job title.
- View yourSubscription Service Agreementvalue.
If the value is:
- UMSA, the feature is automatically available. You can skip theEnable Innovation Services Feature and AI Data Contributions for MSA Customersstep. For more information on Machine Learning data contributions, see Concept: Workday AI for Universal Main Subscription Agreement Customers.
- MSA, you must enable this feature through Innovation Services using theEnable Innovation Services Feature and AI Data Contributions for MSA Customersstep.
Note: UMSA customers don't have Innovation Services tasks and reports in their tenants as these are for MSA customers only. UMSA customers can ignore all information regarding Innovation Services.
When setting up Worksheets, give access to all users and groups that might use Worksheets in different areas of Workday. Example: Workday Slides users use Worksheets to set up defined names and pivot tables for use in Slides presentations.
- You might need to take additional steps to enable this feature depending on your organization's subscription service agreement. For more information, see this Community article.On theInnovation Services Opt-Intask, select theProductivity Suite ML Featuresservice on theAvailable Servicestab in theCross Application Servicescategory.
- Create security groups for Worksheets administrators and users.Use these security group types:
- Public groups
- Role-based (constrained) groups
- Unconstrained groups
- Create or edit a security policy for these domains and add permissions:
- Worksheets
- Manage Bot and User Conversations
- Access theView Domainreport.
- Select the domain from theDomainprompt.
- From the related actions menu, select , or selectEdit Security Policy Permissionsif there's an existing policy.
- As applicable, inReport/Task Permissions, add, or edit security groups.
- Select theViewandModifycheck boxes.In the domain setup, you must select bothViewandModify. You can't use these settings to manage workbook access. You select view and edit permissions for individual workbooks when you share them.
- From the related action menu on the domain security policy, select .
- Activate Pending Security Policy Changes.
- Sign out and sign back in to see your changes.
- To enable Formula Writer and Explainer functionality in your tenant, access theEdit Tenant Setup - Systemtask. In theWorkday Conversation Settingssection, select theEnable Worksheets GenAI Featuresoption.
- In , make sure that you include the WXF file type and all other file types that you want to support in Worksheets, or select to support all file types.We recommend supporting these file typesin addition toany other file types that you want to support in your tenant:
- CSV
- HTML
- XLS
- XLSM
- XLSX
See Steps: Set Up Drive. - (Optional) Access theEdit Tenant Setup - Systemtask.Configure settings for workbook downloading and commenting, and the user feedback survey.In theDrive Settingssection, use theDisable Workbook Downloadcheck box to select whether to prevent users from downloading workbooks out of Workday. Example: If selected, users can't download workbooks to Excel, PDF, or CSV files. After you change this setting, you might experience a delay of up to 65 minutes before the change takes effect in Drive.In theWorkday Conversation Settingssection, use theDisable Comments for Worksheetscheck box to select whether to prevent users from adding or viewing comments. If selected, the Collaborate panel doesn't display in the web browser or in the mobile app for any workbook, regardless of the user's permission settings for the workbook. Worksheets preserves existing comments and restores them when you enable commenting again. The Can Comment permission level continues to display when sharing files; if you disable commenting, the Can Comment permission level is the same as Can View.After you change this setting, you might experience a delay of up to 5 minutes before the change takes effect in Worksheets.In theUser Feedbacksection, use theOpt-out of Intercept Surveycheck box to select whether to disable all ad hoc user feedback surveys across the entire tenant. Opting out prevents Worksheets,and all other Workday applications, from displaying a survey to a subset of users after complete an action in a workbook.
- (Optional) Configure system settings for Worksheets notification delivery.Access theEdit Tenant Setup - Notificationstask. In the section, customize notification settings for Worksheets:
- Workbook Access Additions (not currently used).
- Workbook Access Removals (not currently used).
- Workbook Comments (not currently used).
- Workbook Conversations: Workday sends a notification, and also sends an email if enabled on the tenant, to tagged (@mentioned) users in a workbook comment.
- Workbook Import Failures: Workday sends a notification, and also sends an email if enabled on the tenant, when a file upload to Drive fails.
- Workbook Import Successes: Workday sends a notification, and also sends an email if enabled on the tenant, when a file upload to Drive succeeds.
- Workbook Live Data Scheduled Updates: Workday sends a notification, and also sends an email if enabled on the tenant, when you schedule a live data refresh.
- Workbook Notify If Function Notifications:Workday sends a notification, and also sends an email if enabled on the tenant, when the results of a NOTIFYIF or NOTIFYIFS formula meet the criteria that you defined.
- Workbook Tasks (not currently used).
- If Worksheets hasn't been translated into the language that a user selected as their display language, your security administrator must access theEdit Workday Accounttask for the user and select theAllow Mixed-Language Transactionsoption. This makes the Worksheets user interface visible to the user in English.