Forum Discussion
Power Query hangs Excel
my best guess is if you are reading the file from a shared folder or an online site, local sharepoint also, there can be an issue with access rights. please check this first as the total of 9000 rows is not a restriction for Power Query.
Thank you for the suggestion. It turns out that wasn't it but I will keep that in mind in the future. The fix, I think, was removing all of the .com add-ins and then re-adding them one at a time. I did that, added them back and now everything works. I wish I knew what removing them and re-adding them accomplished but that was what I did right before it started working again. I don't understand why it stopped working in the first place. Maybe the last upgrade produced a conflict? But I'm just grateful it works again. Thank you again for responding. erol sinan zorlu