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...
Hi NikolinoDE
Thanks for the response, I have tried some of this, but as per my post, I think these are highly unlikely to be the problems, to reiterate:
- the file opens fine on a laptop with an older version on Excel, so it is not corrupted
- even if it WAS corrupted, how could all the old versions of the file, which had not been opened in some cases for over year, corrupt at the same time (saved on different drives, local and the cloud)
- the file suddenly stopped opening on 2 separate PCs (with different hardware, graphics cards/drivers etc), on the exact same day, so it is highly unlikely this problem is PC related - how could they both go wrong in the same way at the same time? It could maybe be a virus issue, but:
- the file will not open in Excel in the browser either (where it would before) - as a browser version of Excel it is not affected by any hardware issues, except those affecting the browser itself.
So it seems to me the most logical culprit is Excel itself, both desktop and that running in the browser.
Thanks for the response, I have tried some of this, but as per my post, I think these are highly unlikely to be the problems, to reiterate:
- the file opens fine on a laptop with an older version on Excel, so it is not corrupted
- even if it WAS corrupted, how could all the old versions of the file, which had not been opened in some cases for over year, corrupt at the same time (saved on different drives, local and the cloud)
- the file suddenly stopped opening on 2 separate PCs (with different hardware, graphics cards/drivers etc), on the exact same day, so it is highly unlikely this problem is PC related - how could they both go wrong in the same way at the same time? It could maybe be a virus issue, but:
- the file will not open in Excel in the browser either (where it would before) - as a browser version of Excel it is not affected by any hardware issues, except those affecting the browser itself.
So it seems to me the most logical culprit is Excel itself, both desktop and that running in the browser.
Hi, did you ever get this resolved? I seem to have a similar problem where my .xslb file immediately closing when opening with no error message. Excel then does a repair and it works. But after a while making some macro changes, it happens again. I have tried removing all macros and reloading. Same problem after a while. I am on Windows 10, Office 360 16.0.16501.20074 64 bit.
BTW. My Workbook has 82 sheets and 276 marcos.
Duwat13 Sorry no. I was able to convert the file to .xlsm and all was fine. It did take a bit of sorting, but if you are able to open the file occasionally then I'd do this. For me, the only real advantage to a .xlsb file was smaller file size, but not much of an advantage if it doesn't work....!