You can make Excel always open old spreadsheets in Protected View. Enable or disable Protected View using in-built setting, Group Policy, Registry.

If you cannot open an Excel file and see Excel cannot open the file because the file format or extension is not valid error, see this post.

Learn how to use a Microsoft 365 setting to choose whether to open files in the online or desktop app, giving you full control for each file.