Forum Discussion
ImadHimo
Nov 11, 2022Copper Contributor
Excel crashing after selecting a formula
Hi everyone, I am facing an issue with Excel. When I select a formula in a cell, Excel crashes. When I write the formula, it works fine but when I select it from the list, it crashes. Could anyon...
- Dec 04, 2022
ImadHimo it's happens on my HP Omen laptop with office 2019 home and student, and i found that omen gaming hub (Factory App) make it crash. i uninstall it and my excel working fine.
ImadHimo
Nov 22, 2022Copper Contributor
Hi everyone,
I contacted the Microsoft support Team, they couldn't offer any help, they said I can write a feedback and maybe I get a response.
In my case the problem disappeared the next day after I noticed the issue. I did nothing to fix it.
I contacted the Microsoft support Team, they couldn't offer any help, they said I can write a feedback and maybe I get a response.
In my case the problem disappeared the next day after I noticed the issue. I did nothing to fix it.
JKPieterse
Nov 22, 2022Silver Contributor
I have notified the Excel team about this too, perhaps that will give this some traction.
- Steve_K_ExcelNov 22, 2022
Microsoft
Hi All - Thanks for reporting this here and for submitting feedback about this issue. We (Excel team at Microsoft) have a fix for this issue and it will be released very soon.
- SteveS1160Nov 22, 2022Copper Contributor
- JKPieterseNov 22, 2022Silver Contributor
Steve_K_Excel thank you for jumping in!
- Steve_K_ExcelNov 22, 2022
Microsoft
Another workaround is to simply type the entire function name that you'd like to use, rather than selecting it from the drop-down list.
The fix will be available in the next update for Insiders Beta. It will be version 16.0.15917.20000 or greater. The fix will be available to other update channels soon.
- rasridhoNov 22, 2022Copper Contributor
Steve_K_Excel thank you steve! Please fix it ASAP because it ruined my other worksheet.
- Steve_K_ExcelNov 22, 2022
Microsoft
In the meantime, you can work around the issue by using the Formula Builder dialog. To open it, press Shift+F3 or click on the Fx button next to the formula bar when you want to create or edit a formula.