Excel crash on loading .NET framework

[jonas-martens]

Hi All,

I have a file containing quite some macro's as well as some PowerQuery connections to other Excel files.
This file is created for a company which is using it over multiple computers.
On 7/9 computers this works perfectly, on 2/9 it crashes on start-up.
At the bottom right, I see "Loading .NET framework" and this is loading for +/- 2mins. After that, Excel crashes.

I'm unable to open that file on those two particular pc's. On one of both, I never was able to open the file, on the other I was able to for a while and then suddenly I wasn't able anymore.

After doing some research, I found this has a relation with PowerQuery? Any suggestions on fixing this?
Both Windows and Office are fully up to date, same O365 versions on all pc's.

Thanks a lot.

[jdelano]

Have you tried looking in the Windows Event Viewer to see what (if any) errors Windows might be logging when this happens?
https://www.pcmag.com/news/how-to-tr...a-event-viewer

Do those machines have at least 4.7.2 installed?
https://support.microsoft.com/en-us/...e-5bfb1a6c536a

You could try to repair .Net framework using this tool https://support.microsoft.com/en-us/...6-c34a2f4b612a

[jonas-martens]

Hi Jdelano,

Tried to update to the latest version as well as the repair tool but none of it worked unfortunately.

[jdelano]

Is there any useful information in the Event Viewer?
You might find more help here https://powerusers.microsoft.com/t5/...p/MPACommunity as well.

[jonas-martens]

No unfortunately not.

Even uninstalled and re-installed O365 again. without success...
Shitty stuff :-/

[jdelano]

The only other things I might try would be:

• Create a new windows user (maybe the profile is corrupt)
• run dism /online /cleanup-image /restorehealth and sfc /scannow in a command prompt opened as admin to check for corrupt system files
• then the nuclear option of a clean install of Windows

I hope the Power Query forum can help you out. Those types of issues are maddening.