Recent DiscussionsMost RecentNewest TopicsMost LikesSolutionsTagged:TagRe: Send email when a column is not filled in excel onlineYou can follow this tutorial and use Office Scripts and Power Automate to implement this solution: https://docs.microsoft.com/en-us/office/dev/scripts/resources/scenarios/task-remindersRe: Excel Script - Refresh data PDTaylor Currently, pivot table refresh/Power Query refresh is not supported with Office Scripts. If you would like to see this feature in the Office Scripts feature-set, please upvote this request here: Enable Office Scripts to refresh Power Query queries · Community (microsoft.com). Re: importing data from multiple worksheets into one table Debbie57 Yes, you can do this by using Office Scripts and Power Automate. You can create a Flow that gets all the workbooks in a SharePoint folder. Then, using the Run Script action in the Excel Online Business connector, you can run an Office Script on each of those workbooks to get the specific data you need and add that data into a table in another sheet. Here is some documentation about Office Scripts as well as how to get started using Office Scripts and Power Automate. Let me know if you need any additional help! Re: office script feature Elton_Gomez_DIAN2021 You can share Office Scripts with others by sharing it within a workbook. As long as the other users have edit access to the workbook you share it in, they will have access to view and run the script. You can learn more here.
Recent Blog ArticlesNewest TopicsMost LikesTagged:TagAdvanced Formula Environment is becoming Excel Labs, a Microsoft Garage Project! Today, we are thrilled to announce our continued investment in experimentation through the release of Excel Labs, a Microsoft Garage project. Excel Labs is an add-in that allows us to release experim...Office Scripts is now generally available in Excel for the web We are happy to announce that Office Scripts in Excel for the web is now generally available for all eligible users!
MicrosoftMicrosoftMicrosoftMicrosoft
