Not sure this is the right forum but was referred here from the 365 / Excel Forum.
Issue:
Excel crashes immediately after:
Trying to refresh existing queries loaded on a sheet
Trying to load a query to a new sheet
Loading Query as connection only or refreshing query from the PowerQuery editor without loading causes no issues
Crash Details:
- No errors are displayed right before or after crash.
- After crash, Excel recovery opens .xlsb file.
- Data size, source connection type, or query complexity does not make a difference.
- In the Recovered .xlsb file in the Queries & Connections panel a warning message is displayed for all queries: "All External Data Connections have been disabled".
Other relevant details:
- Issue started happening only after updating to Microsoft® Excel® for Microsoft 365 MSO (Version 2407 Build 16.0.17730.20000) 32-bit.
- All queries that used to work prior to update, now cause excel to crash upon refresh or when trying to load query to sheet.
- Tested same queries on 2 different machines and no issues.
- Queries produced no isses on machines running earlier versions/builds (ex. tested on Version 2403 Build 17425.20236)
Troubleshoot steps tried:
In last 2 days have tried all of the following to no avail:
Not sure what next steps to follow or if reverting to my previous Office/Excel version is an option.
Versions/Build used:
Many blessings & thank you for any guidance anyone can provide.
