Forum Discussion
Power Query in Excel / all Power Query related commands in Excel cause crash of Excel
Dear all,
SUCCESS!!!
After a period of quieteness I want to keep you updated.
There was a solution to my problem.
Several kind forum members gave a lot of tips and hints for which I thank you very much again!
In some posts it was recommended to reinstall/actualize the MS365 package.
I did this and unfortunately it showed no result in a first try.
Then v-junyant-msft (Dino Tao) lead the attention to a perhaps other available computer.
I found out that on another machine MS365 was installed in 64 bit version whereas on my personal machine for what reason ever it had been installed in 32 bit version.
The process to solution:
- completely deinstall existing 32 bit MS365 package and all office desktop Apps via local settings
- install 64 bit MS365 package via MS-website
Meanwhile I've verified
- no crashes for new, blank files
- no crashes for "problem"-file including actualizing existing links and queries to 305 csv-files on local hard drive
I've to confess I don't know whether this is a generic solution to all similar issues or a more specific one.
Also I have to state that in the first attempt to renew the initial MS365 package I processed this via the MS-website which offers to call all Apps to be installed on a computer and did not really deinstall/remove the exisiting package (allways talking about 32 bit)
In any way for a similar issue I would suggest to really remove/deinstall the existing package and not rely simply on the process via MS-website hoping that it will clean the machine sufficiently before installing the new set of files.
Greetings and again thanks to all
DR_99
Dear all,
I've meawhile applied the most substantial method; I've reinstalled the entire MS365 package.
BUT:
My problem still persists 😞
I must confess I'm getting more and more desperate.
Is there perhaps any other helpful advice bearing in mind that there were several real good ones yet?
Kind regards
DR_99
Hi DR_99 ,
I'm sorry to hear that you've tried most of the possible solutions and still can't solve the problem.
Do you have any other available computers other than your current one to accomplish what you need to do? If so, I would suggest that you try another computer to see if the problem still exists.
Because:
Yes absolute new and blank files (xlsx) cause the crashes described.
This is without having done anything to the file.
It's just this new one Excel creates in the first second.This doesn't seem to be due to a problem with Power Query or excel, but more like a problem with your computer itself (e.g., some configuration file is missing, or the configuration file is corrupted, etc.)
If it works fine on another computer, it's most likely a problem with your computer itself. You can open your computer's Event Viewer after a crash to see if you can get some error messages.
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.