Dear All, for almost 2 years now, I have been experiencing constant crashes, file corruption, and rebuild. The number of hours I have lost doing open Open & Repair's or Project Cleaning is countless.
At last, a set of tools from
Home not only found the problem, but fix it on the first install.
I don't know what to say to the production team of these tools, other than the biggest thankyou that I can give. Since installing Ribbon Commander, not a single crash - Not one!!!!!!
This is unheard off for over 18 months. This workbook which was being corrupted everyday, 3,4,5,6 times day has now not crashed for two weeks.
Upon install Ribbon commander identified some remnant code from an add-in that was long since removed. No other tool was able to identify this.
I did
every suggest remedy available over the last 18 months, from removing all conditional formatting, debloated, cleared unused ranges (several methods), breaking the working up into smaller components, removing unnecessary code, removing unnecessary sheet, purchasing several tools that promised to fix the issue, upgraded system memory, getting office 365 and windows 11 up to date at all times etc etc etc.
With a huge amount of hesitancy, I really didn't want to buy an another empty promise. But I took the plunge again and for the last two weeks I have enjoyed trouble free modelling.
These tools are without any doubt, well worth every penny.
That address again is
Home.
Thank you all for the many suggestions to help solve this problem. all of your experience is truly extremely valuable.