Office Scripts
486 TopicsAutomate your tasks with the Automate tab—now in Excel for Windows and Mac
The Automate tab is growing beyond your web browser and onto your desktop! Starting today, the Automate tab is now available for all eligible users in Excel for Windows and Mac. Previously, this tab was only available in Excel on the web.293KViews5likes49CommentsHow to Autofill one sheet based on a table made in another sheet.
Hello, I am struggling to find the right formula that will let me fill Sheet 2 Column B based on the value in Column A. In the reference table made in another sheet I have all possible Column A values and the Column B values that match. What is the best formula to use. It will need to see that the A column cell matches the A column cell in the other sheet and then fill the corresponding B,C,D and E column values. But just filling column B is most important. Thank you for any help. I know EXCEL is very powerful and has the ability to do stuff like this. Until then I am copy/pasting values across which when some tables have 45 rows and there's 60 tables is a huge waste of time. Sheet 2 Reference TableSolved176KViews0likes3CommentsNeed to search multiple words in a cell and get the output based on the word found.
Hi, I am having a data in column A like below, then I need search for multiple words like "Generic Mailbox", "Distribution", "Non-standard", "NSSR" in the each cell and then if "Generic mailbox" is founds in the cell, output should be "shared mailbox" or If "Distribution" is founds in the cell, output should be "DL" or If "Non-standard" is founds in the cell, output should be "Corporate request" or If "NSSR" is founds in the cell, output should be "Non-Standard Service request" Looking for to get help on this!! Thank you.Solved100KViews0likes46CommentsExcel Script - Refresh data
Hi, I have an excel file which has a data connection. I have been trying to get the data and associated pivot tables to refresh through a script but it doesn't seem to work fully. The script is as follows: function main(workbook: ExcelScript.Workbook) { // Refresh all data connections workbook.refreshAllDataConnections(); workbook.refreshAllPivotTables } I am prompting the script to run through PowerAutomate a couple of times a day. The file will appear to be modified (last modified date of file reflects when the script was last run through PowerAutomate) but the data in the Pivot table is not up to date from the data source. If I open the file online will get a message to enable the queries so I don't know if this needs to be part of the script too? Any thoughts? Thanks40KViews0likes8CommentsCalculating (12 Threads): 0%
Good morning! Office 365 user. With the addition of a few new formulas, my spreadsheet has become very laggy. I now see the above subject line in the status bar of my application. We're talking 15-20 second delays with every change to the drop-down list. Any suggestions to relieve this?Solved29KViews0likes5Comments2013 doesn't have =filter() function. ANY alternate function?
I have Microsoft excel 365 in that filter function is available and i create a follow up sheet linked with database sheet where in database user will store data from the form. In database there is a column Follow up date. I want to show the all the data which will meet a date condition. I have done by using filter function but in 2013 it doesn't have filter function what function can i use to perform the same operation?23KViews0likes3CommentsAnnouncing buttons for Office Scripts: Run scripts with a workbook button
Starting today, you—and your colleagues—can run Office Scripts by pressing a button within a workbook. This highly requested feature introduces a new way to share scripts with colleagues, making it easier for users to find and run your scripts.21KViews8likes27Comments