A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Hi! Sorry to hear that you have troubles with this situation, please try this steps:
- Copy one of the “bad” workbooks to your Desktop and try again. If it opens, the USB cable/port or the external drive is the problem, replace the cable, use another port, or work from the internal SSD.
- Launch Excel in Safe Mode Win + R >excel /safe. If it opens, an add-in is crashing Excel. Disable all COM Add-ins in File > Options > Add-ins > Manage COM Add-ins > Go, and re-enable one at a time to find the problem.
- Turn off hardware-graphics acceleration. File > Options > Advanced > Display > tick Disable hardware graphics acceleration.
- Run a Quick/Online Repair of Microsoft 365. Settings > Apps> Microsoft 365 > Modify > choose Quick Repair.