Excel Shape Keeps Disappearing (Four Fixes)

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

Where Are SQL Express Databases Located?

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

Power Automate Desktop URL Syntax Error (Fixed)

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

Power Automate Create Excel File (Tutorial)

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

How to Combine Multiple Worksheets in Excel

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

How to Disable Protected View In Excel 365?

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