"The file you are trying to open, [filename], is in a different format than specified by the file extension" error opening Excel files

When trying to open an Excel file, you may run into the following error: “The file you are trying to open, [filename], is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trustworthy source before opening the file. Do you want to open…