Forum Discussion
No fix for Excel crash
Thanks mathetes
- Excel was working perfectly (to my knowledge) up until the point it wasn't. I bought this machine about six months ago
- Excel started to exhibit this behaviour 24 hours ago and continues to act in this way
- There were no hardware or software changes/updates/installations that took place
- Excel crashes regardless of which formula I am using. If I type the formula out rather than selecting the suggestion, it works fine. As soon as I select a suggestion from the autogenerated list, it crashes without warning or an error message. It sounds like a trivial thing, but actually it's made me realise how much I rely on the suggested list to save time (I use Excel rather a lot). So yes, typing something like, "=max(a1:a12)" works fine. Typing "=ma" and then select Maximum from the list makes it crash instantly
- The suggestions are generated by Excel and normally a single or double (i forget which) click on the required formula selects it without issue
- This happens with every spreadsheet including opening a new empty sheet
- I update Windows and Office about a week ago, and have been using Excel without issue until yesterday
- I'm not placing a large amount of strain on my system, or Excel. Using Excel fluently is not really possible in the browser. Often my demands on Excel are high and Excel online is not a long-term solution
- This problem happens with all workbooks, empty ones and large ones
- I have another user account on this PC and an MS Office subscription which includes Excel, and this remains free of problems
Update: I had a call with Microsoft at lunch today. We installed a previous version of Office, created a new user account on my desktop and accessed Excel through the same credentials. The engineer was unable to identify the cause of the problem and has referred it to back-office consultants after recording the problem through Quick Assist and Steps Recorder. Apparently, this problem has not been encountered previously, but I'm hopeful for a solution as it makes life extremely difficult working with data and dashboards.
I would be eternally grateful if you know of some magic to solve this issue!
Thanks
- I have another user account on this PC and an MS Office subscription which includes Excel, and this remains free of problems
Based on this, I'm inclined to agree with Patrick2788 that the primary cause is outside of Excel. Yet clearly Excel is involved, or Excel on this particular user account.
Update: I had a call with Microsoft at lunch today. ... installed a previous version of Office ... a new user account ... accessed Excel ... The engineer was unable to identify the cause ... referred it to back-office consultants after recording the problem. ... Apparently, this problem has not been encountered previously, but I'm hopeful for a solution
I share the hope. Please let us know the outcome, just to close the loop.
Thanks both, I will be sure to let you know when this is resolved and (if I know) what the remedy was,
Sam
Sam_Newton have you had a solution presented to you yet? I've lost hours of work already this morning with excel crashing. Felt like throwing my laptop out the window earlier!
Success!!!! Excel appears to be functional again.
The engineer has very kindly outlined the steps that we took and I've snipped them and inserted below. Please don't ask me any technical questions - they are unsure how the file became corrupted. Since there has been no trigger identified, I have requested the ticket be left open for a week while I monitor Excel. But, so far, so good!!
Hope this helps:
Sam_Newton I've recently encountered the exact same issue.
The first time I had this issue was yesterday, i was editing a large formula by inserting a "left" command, the suggested formula came up part way through typing, i double clicked on the suggestion, excel closed upon doing this and I lost a load of work.
I repeated the same thing and it happened again... I thought ok, maybe its the workbook, tried a blank workbook, happened again.
Uninstalled office 365 and removed all temp files, reinstalled and it happened again.
Not much of an idea on what to do now.
Andy_McNichol I'll post back here with the solution if Microsoft are able to get back with one.
