Forum Discussion
Excel crashes when opening a specific (complex) .xlsb file (and all previous versions of it too)
I have a business critical Excel .xlsb file, that I have been updating/using for years (it contains about 20 sheets, and a lot of VBA code - none of which runs on opening). Yesterday, the file ref...
Orghal Today I had a very similar problem. A complex Excel powerquery file (no VBA though) suddenly freezing Excel every time I open it (Windows 11 + Office 365). Strange enough, the same file would open fine on another PC (with very similar setup Wni11 / Office 365).
And COPYING the file did also the trick ! Note that just changing the name of the file was not enough.
If not reading that post I would have never tried it.
So thanks a lot but so puzzled by such MS quirk!
Hi,
no problem. I still fight with this bug and one more thing I read here - hidden file. Need to check what is it because in my opinion m$oft never fix any bugs. Any one who is called programmer and coming from this fake company should be kicked out and redirected to selling fishes in any simple market.
There is additional trick which I use last 2 months and cannot understand but it helps.
My code at all in one automation has already 2700 code lines (paragraphs count, real pages code it is more than 6k). Every time before I go to close this workbook after never mind what I do, change or update - even if it's just functions or sheets graphic form changes, and not VBA, anything. I always opening editor with largest module (around 1k lines). Select all -> Cut (Control+X) -> Close module -> open it again -> paste source as it was before with removing last 2 empty lines always appeared at the end (maybe m$oft still don't know how to make proper copy-paste action). Then I saving workbook file and closing it. Reopen and there is no problem, simple test click any button and no errors about disabled macros or not existing sources.
This operation do not provide to crash and unidentified disappearance of source codes not known where from the document. That's why also all the time I copying all sources (Modules) to separated Notepad and save as backup.
Sometimes Excel is screaming when you run any code from buttons, actions etc. which sounds like "macros disabled or not exists". What help here? very simple... of course if you can see any modules in Editor just take largest one and re-copy-paste sources as it is without any changes (only those two empty additional lines to remove). In my situations it always works 99.99%. Maybe once for 100 situations excel crash just like before so I re-copy all from notepad and workoook back to work. Don't know why, how and what kind of idiot in m$oft create it. Must be total amateur and perfectly not skilled dumb. Every thing 100% what m$oft touch is always destroyed without any exceptions.
Sad, no one from this amateurs and managers read this forums and will never take into consideration our experience and very long experiments on how to prevent problems. This should help locate the problem and fix it. After all, they must still have somewhere the source codes of their software and someone can check it. Just a child 12-15 years old is enough, because he will already have more experience in coding than a m$oft employee.
Regards to all
no problem. I still fight with this bug and one more thing I read here - hidden file. Need to check what is it because in my opinion m$oft never fix any bugs. Any one who is called programmer and coming from this fake company should be kicked out and redirected to selling fishes in any simple market.
There is additional trick which I use last 2 months and cannot understand but it helps.
My code at all in one automation has already 2700 code lines (paragraphs count, real pages code it is more than 6k). Every time before I go to close this workbook after never mind what I do, change or update - even if it's just functions or sheets graphic form changes, and not VBA, anything. I always opening editor with largest module (around 1k lines). Select all -> Cut (Control+X) -> Close module -> open it again -> paste source as it was before with removing last 2 empty lines always appeared at the end (maybe m$oft still don't know how to make proper copy-paste action). Then I saving workbook file and closing it. Reopen and there is no problem, simple test click any button and no errors about disabled macros or not existing sources.
This operation do not provide to crash and unidentified disappearance of source codes not known where from the document. That's why also all the time I copying all sources (Modules) to separated Notepad and save as backup.
Sometimes Excel is screaming when you run any code from buttons, actions etc. which sounds like "macros disabled or not exists". What help here? very simple... of course if you can see any modules in Editor just take largest one and re-copy-paste sources as it is without any changes (only those two empty additional lines to remove). In my situations it always works 99.99%. Maybe once for 100 situations excel crash just like before so I re-copy all from notepad and workoook back to work. Don't know why, how and what kind of idiot in m$oft create it. Must be total amateur and perfectly not skilled dumb. Every thing 100% what m$oft touch is always destroyed without any exceptions.
Sad, no one from this amateurs and managers read this forums and will never take into consideration our experience and very long experiments on how to prevent problems. This should help locate the problem and fix it. After all, they must still have somewhere the source codes of their software and someone can check it. Just a child 12-15 years old is enough, because he will already have more experience in coding than a m$oft employee.
Regards to all