Excel 2016 closing unexpectedly - Diagnostic Log location

To troubleshoot Excel 2016 closing unexpectedly, you can gather diagnostic logs to pinpoint the issue. Here’s where to look:

1. Office Diagnostic Logs: Excel automatically generates logs that can help identify crashes. You can find them in:

   • Windows: %temp%\Diagnostics\UploadCache

   • Android: Location varies by device

2. Event Viewer Logs:

   • Open Event Viewer (Win + R, type eventvwr, press Enter).

   • Navigate to Windows Logs > Application.

   • Look for Excel-related errors.

3. Increase Log Size for More Data:

   • Microsoft allows increasing the default log size to capture more details.

   • You can use the script to expand log collection.

4. Crash Dumps:

   • If Excel crashes frequently, Windows may generate crash dump files in %AppData%\Microsoft\Excel.

5. Check for Add-in Issues:

   • Run Excel in Safe Mode (Ctrl + launch Excel).

   • Disable add-ins via File > Options > Add-ins.

If you need deeper analysis, you can compress and send logs to Microsoft Support for further investigation. Let me know if you need help interpreting the logs!