Excel Files Crashing - .xlsb, but not .xlsm

%3CLINGO-SUB%20id%3D%22lingo-sub-1669789%22%20slang%3D%22en-US%22%3EExcel%20Files%20Crashing%20-%20.xlsb%2C%20but%20not%20.xlsm%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1669789%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20issue%20started%20up%20over%20the%20weekend%2C%20first%20on%20my%20desktop%20and%20one%20other%20user's%20computer%2C%20and%20this%20morning%20it%20started%20on%20my%20laptop.%20I%20maintain%20a%20design%20tool%20in%20excel%2C%20with%20multiple%20iterations%20over%20the%20past%202%2B%20years.%20Starting%20this%20weekend%2C%20none%20of%20the%20files%20are%20able%20to%20be%20opened%2C%20even%20the%20oldest%20ones%20from%20years%20ago.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20tried%20the%20following%20steps%3A%3CBR%20%2F%3E-%20Uninstall%20and%20reinstall%20Office%2C%20as%20well%20as%20repair%3CBR%20%2F%3E-%20Save%20the%20file%20multiple%20times%20from%20a%20computer%20where%20it%20works%2C%20and%20send%20it%20to%20myself%3C%2FP%3E%3CP%3E-%20Open%20the%20file%20in%20Protected%20View%3A%20If%20calculations%20are%20set%20to%20automatic%20it%20will%20still%20crash%2C%20but%20it%20will%20work%20if%20calculations%20are%20set%20to%20manual%20before%20opening%20the%20file%20in%20question.%3C%2FP%3E%3CP%3E-%20I%20have%20repaired%20my%20installation%20of%20Visual%20C%2B%2B%20on%20both%20computers%3C%2FP%3E%3CP%3E%3CBR%20%2F%3E-%20I%20have%20saved%20the%20file%20as%20a%20xlsm%20instead%20of%20xlsb%2C%20and%20then%20the%20file%20does%20work%20successfully.%3C%2FP%3E%3CP%3E-%20Upon%20re-saving%20this%20file%20back%20to%20xlsb%20format%2C%20it%20crashes%20upon%20opening%20again%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3EOne%20thing%20I%20noticed%20this%20morning%20is%20that%20when%20I%20open%20the%20Object%20browser%20for%20the%20xlsb%20version%2C%20it%20will%20say%20%22Object%20library%20invalid%20or%20contains%20references%20to%20object%20definitions%20that%20could%20not%20be%20found.%22%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EMy%20laptop%20updated%20again%20this%20morning%2C%20and%20it%20began%20to%20crash%20after%20that%20update.%20I%20reverted%20the%20updates%20and%20the%20file%20didn't%20crash%2C%20until%20an%20Intel%20Graphics%20driver%20was%20installed.%20I%20reverted%20the%20driver%20after%20that%20error%20returned%2C%20but%20it%20still%20will%20not%20work.%20From%20my%20bit%20of%20googling%2C%20I%20am%20wondering%20if%20the%20above%20findings%20indicate%20there%20is%20some%20sort%20of%20issue%20with%20VBA%2C%20or%20the%20graphics%20driver%3F%3CBR%20%2F%3E%3CBR%20%2F%3EAny%20help%20would%20be%20immensely%20appreciated%3B%20if%20this%20issue%20becomes%20much%20more%20widespread%20it%20will%20drastically%20affect%20our%20ability%20to%20work%20effectively.%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1669789%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

This issue started up over the weekend, first on my desktop and one other user's computer, and this morning it started on my laptop. I maintain a design tool in excel, with multiple iterations over the past 2+ years. Starting this weekend, none of the files are able to be opened, even the oldest ones from years ago. 

I have tried the following steps:
- Uninstall and reinstall Office, as well as repair
- Save the file multiple times from a computer where it works, and send it to myself

- Open the file in Protected View: If calculations are set to automatic it will still crash, but it will work if calculations are set to manual before opening the file in question.

- I have repaired my installation of Visual C++ on both computers


- I have saved the file as a xlsm instead of xlsb, and then the file does work successfully.

- Upon re-saving this file back to xlsb format, it crashes upon opening again


One thing I noticed this morning is that when I open the Object browser for the xlsb version, it will say "Object library invalid or contains references to object definitions that could not be found." 

My laptop updated again this morning, and it began to crash after that update. I reverted the updates and the file didn't crash, until an Intel Graphics driver was installed. I reverted the driver after that error returned, but it still will not work. From my bit of googling, I am wondering if the above findings indicate there is some sort of issue with VBA, or the graphics driver?

Any help would be immensely appreciated; if this issue becomes much more widespread it will drastically affect our ability to work effectively.

Thank you,

0 Replies