I used an Excel shape to make a nice-looking button that runs a macro on a protected worksheet. The shape frequently becomes invisible with repeated use of the worksheet and button. But the object hasn’t moved or been deleted from the sheet. I know this as I can still click the shape when I hover … Read more
There are three easy ways to find where your SQL Express database is located. Before we go through them step by step, I’ll quickly explain how your databases are stored. You may be surprised to learn that a database has more than one file. How SQL Express Stores Databases In Files Each SQL Express database … Read more
When I installed version 18 of SQL Server Management Studio, it was taking over two minutes to launch and complete the start-up. Here are seven different tips to prevent a slow SSMS start-up. I’ve listed them in order of which ones you should try first. I’ll also mention some associated disadvantages that may make you … Read more
You may see some articles saying that SQL Express does not require a license. That is not true – which you’ll find out when you try to install the software. The license gives you free usage of the software which is a limited version of its big brother, SQL Server. However, the license forbids using … Read more
I recently encountered the problem where I was trying to add a filter on the top row but Excel kept putting it on the second row. Here’s a picture of this annoying problem: Although I have placed the cursor on the first row and the B1 cell is highlighted, Excel insists on putting the filter … Read more
Have you been clicking around in Power Automate Desktop and wondering where the option is to copy a flow? I spent five minutes trying to figure out where Microsoft had buried the “copy” button in PAD. It turns out that there isn’t a copy button in the desktop application. However, there are several other ways … Read more
Power Automate Desktop lets you enter URL addresses in several tasks including the “Go to web page” task. Sometimes you may see an “Invalid value” message or a syntax error. This article shows you how to fix this. Example of Invalid Value Message In this example, a URL is entered into the input box: https://bandittracker.com/?info=hello%20world … Read more
This quick tutorial shows you how to use Power Automate Desktop to create and save an Excel spreadsheet. You’ll learn how to use Power Automate Desktop to: Launch Excel on your local machine Create a new Excel workbook Write content to a worksheet Close and save the Excel file to a specific location Prerequisites You … Read more
I wanted to combine the contents of multiple worksheets in an Excel file. The method in this tutorial will concatenate some or all of the worksheets in a single file into a new worksheet. If you have data spread across multiple Excel files, you can simply repeat the process for each file. Format Of The … Read more
This article shows you how to disable Protected View in Excel 365. This stops Excel from opening spreadsheets in protected mode. You will no longer see the warning message at the top of the screen. You should only disable Protected View when you are downloading and working with Excel files that you are certain are … Read more