Forum Discussion
NerdyBen
Dec 05, 2019Copper Contributor
Excel files fail to open when PQ is used
Hi folks, I've not found any information on this error, but if it has been posted before let me know. I've run into some kind of bug when I try to open a locally saved Excel file in which Power ...
NerdyBen
Dec 10, 2019Copper Contributor
crazyshoots Thnx for the reply. The power query was not running: it's window was closed. I know I can't even go back to excel while running PQ, because I have to close it first (close&load). Secondly, the query is not huge, about 10k-15k rows, 10 columns. It does load it to excel though, but it should be able to handle that. The file sizes are all under 10 mb and it happens with multiple different files with different queries.
Stephan_Schrandt
Mar 10, 2022Copper Contributor
NerdyBen Did you ever solve this? Thank you.