Forum Discussion
Help! Excel crashing when opening a workbook.
Hi all, Excel on Windows keeps crashing, seemingly randomly with a Workbook with VBA, the VBA has worked for years and the crashing happens only on one specific PC, once the crash happens the file ca...
NikolinoDE
Thanks for your suggestions, much appreciated as Microsoft support are being very unhelpful so far!
All installs are up to date and have no add-ins beyond VBA.
As I explained, what's unusual is that once the file opens its inconsistent as to if it'll crash or not, it's like a 1 in 10 tries on a specific PC which causes the crash. Further, once the crash occurs, the file seems tainted as it'll fail to open on any Windows PC on the business network then but weirdly does open on a Mac OS and saving from that PC (Without any edits) then makes the file un-tainted? All very odd!
I tried an office install repair and a complete uninstall, registry/leftover files purge and re-install both didn't resolve the issue.
I've have tried a file repair and that also seems to work, but I'm apprehensive about what changes the repair has made, is there a log of the fixes it's made so I can verify?
Many thanks in advance!
John.
Thanks for your suggestions, much appreciated as Microsoft support are being very unhelpful so far!
All installs are up to date and have no add-ins beyond VBA.
As I explained, what's unusual is that once the file opens its inconsistent as to if it'll crash or not, it's like a 1 in 10 tries on a specific PC which causes the crash. Further, once the crash occurs, the file seems tainted as it'll fail to open on any Windows PC on the business network then but weirdly does open on a Mac OS and saving from that PC (Without any edits) then makes the file un-tainted? All very odd!
I tried an office install repair and a complete uninstall, registry/leftover files purge and re-install both didn't resolve the issue.
I've have tried a file repair and that also seems to work, but I'm apprehensive about what changes the repair has made, is there a log of the fixes it's made so I can verify?
Many thanks in advance!
John.
When you perform a repair on an Office installation, the repair process typically doesn't provide detailed logs of the specific fixes it makes. However, it's designed to identify and correct issues within the Office installation that may be causing problems, such as missing or corrupted files, registry entries, or settings.
If you are concerned about the changes made during the repair process and want to verify what was modified or fixed, you can try the following steps:
- Check Event Viewer: Look for any related events in the Windows Event Viewer that occurred during the repair process. While the repair process itself may not be logged, any errors or warnings related to Office or Excel may provide additional information about the changes made.
- Review System Logs: You can review system logs and error reports generated by Windows during the repair process. These logs may contain information about the actions taken by the repair tool and any files that were modified or replaced.
- Compare File Versions: After the repair process, you can compare file versions of Office-related files before and after the repair. This can be done by checking the file properties or using third-party file comparison tools. Look for any differences in file versions, timestamps, or sizes.
- Test the File: After the repair, thoroughly test the affected Excel file to ensure that the issue is resolved and that the file behaves as expected. Pay attention to any changes in functionality or behavior compared to before the repair.
- Monitor System Performance: Keep an eye on system performance and stability after the repair. If the issue persists or if you encounter any new problems, it may indicate that the repair did not fully resolve the underlying issue.
If you continue to experience problems or are unsure about the changes made during the repair process, I would recommend contacting your IT support or a trusted support center near you.
Thank you for your patience and understanding.
- NikolinoDE
So an Open & Repair fixes the file, and it's usable for a long while, and then breaks again. When it reoccurs, the file repair again fixes the problem?