Forum Discussion

Witchapon_K's avatar
Witchapon_K
Copper Contributor
Oct 13, 2021
Solved

very very simple query to append tables (connections) make Excel freeze

HI OS Edition Windows 10 Home Version 21H1 Installed on ‎9/‎15/‎2020 OS build 19043.1237 Experience Windows Feature Experience Pack 120.2212.3530.0   Device Processor AMD Ryzen 7 5800X 8-C...
excel
  • Witchapon_K's avatar
    Witchapon_K
    Oct 25, 2021
    Oh, I found the culprit, .xlsb is not supported by power query, and even if you turn the file back from .xlsb it wont fix
WitchaponK's avatar
WitchaponK
Copper Contributor
Oct 14, 2021
I disabled all COM add-in, tried it in safe mode, all doesn't seems to work.
Witchapon_K's avatar
Witchapon_K
Copper Contributor
Oct 25, 2021
Oh, I found the culprit, .xlsb is not supported by power query, and even if you turn the file back from .xlsb it wont fix

Resources