Some Excel features hide in plain sight. They are there, but nobody thinks to click the button. In this post, we are covering one of those features. We are looking at how to create separate sheets for each item in a PivotTable field with the Show Report Filter Pages feature. Excel users love PivotTables because Read More
Category: Office Scripts
How to create user forms in Office Scripts (4 ways)
One of the biggest complaints about Office Scripts is the lack of UserForms. UserForms exist in VBA and display an additional window for collecting user input. Unfortunately, there is no equivalent feature in Office Scripts. However, there are other methods to obtain user inputs that do work with Office Scripts. So, in this post, we Read More
How to create nice looking Office Scripts button (3 ways)
When Office Scripts were released, there were only two ways to execute a script (1) through the script editor or (2) through Power Automate. Users screamed out for a better way. Microsoft delivered a clickable Office Scripts button that could be added to the face of a worksheet. However, the default button style is a Read More
How to email or save Excel images with Power Automate
It is common in many businesses to send regular email summaries or reports to senior executives. Typical scenarios include daily sales reports or cash-flow positions. These emails often contain images displaying the key information. With the current cloud technologies, we now have an easy way to automate this. So, in this post, we look at Read More
How to run Power Automate from Excel with Office Scripts or VBA
For a long time, I’ve been asking Microsoft for the ability to run a Power Automate flow from an Office Script. Office Scripts are restricted to operate only on objects within the workbook. Therefore, we can’t currently run a script that changes another workbook, or undertakes other activities outside of Excel. This significantly reduces the Read More
Hide named ranges in Excel: 4 simple ways
Named ranges are a useful feature of Excel. We often use them to build more complex tools that we may share with other users. Therefore, those named ranges become a critical part of our spreadsheet. Unfortunately, if those users modify or delete the named ranges, it may break the calculations. So, in this post, I Read More
6 ways to make Excel sheets very hidden (invisible)
This week, while working on a project, I wanted to hide a worksheet in Excel. However, I didn’t want users to unhide it or even know it was there. I wanted to make the Excel sheets very hidden (i.e. invisible to other users). I’m sure many users know how to hide a sheet. However, most Read More
Power Automate CSV to Excel (via Office Script: Easy Method)
CSV files are a common file format; they are regularly used to export data from IT systems. Excel desktop can convert CSV to Excel with ease. However, in the online world of Office 365, things aren’t quite so simple. The online world provides us with new automation opportunities not available in a desktop environment. However, Read More
Office Scripts – Sort sheets alphabetically
In this post, we are covering how to sort sheets alphabetically using Office Scripts. Actually, the final code will be flexible enough to sort sheets in many different ways. I’ll share the basic script, along with the steps to create a more dynamic and robust solution. By the end, we will have a script that Read More
Use Office Scripts with Power Automate
In this post, we are looking at how to use Office Scripts with Power Automate. They are both relatively new tools in the online world, and when used together, they create a new ecosystem for automation with Excel. Power Automate is a cloud-based low-code / no-code tool that enables automation through connectors into many Microsoft Read More