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