I?m having trouble opening Excel .xlsm files using VBA.
If there?s a workaround, I?d like to know what it is.
The best case would be to fix this without a workaround.

We have files that were developed and used in 2014 and had since been on the shelf. We are using them again. We were likely using Office 2010 or 2013 I imagine. Now we are using MS365.

Opening manually, I get the attached warnings. For context, there are many identical files, each with different data that can be opened manually.

There is one Summary file which gathers data from the others and provides global controls; the Summary file uses VBA code to open the data files. Now, this fails to open them. I imagine that the popup warnings and required responses are what are causing this.

2023-06-29_09-59-46.jpg
2023-06-29_10-01-24.jpg

The reported xml log has this:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<recoveryLog xmlns=http://schemas.openxmlformats.org/spreadsheetml/2006/main><logFileName>error226000_01.xml</logFileName><summary>Errors were detected in file 'D:\Fred\Documents_on_D\Phase 96 Copy Files\AAON.xlsm'</summary><removedRecords><removedRecord>Removed Records: Sorting from /xl/worksheets/sheet3.xml part</removedRecord></removedRecords></recoveryLog>

I get *nothing* from this?. I don?t know what ?records? were removed nor what they might look like nor where they might be found in the workbook, etc. etc.