Hello everyone!
I really hope anyone can help me on this one. I haven't been able to find help anywhere else or to find a workaround on my own.
I've got a series of queries, their data sources are all within a local excel workbook (no imports from external files, no data connections in the excel file, not even a single external reference in a cell's formula).
The problem starts when I try to refresh any of the queries (either to load it or refreshing the preview) or apply any kind of changes to them (even trying to create a blank one): The whole app will freeze severily. In the best of cases, the refresh will conclude after a very long time, and still the app will continue to freeze or act way slower than it should. All of this will happen while connected to the company's network, as I and the end-users usually do.
Odd enough, if I turn off my wifi adapter (or disconnect from the company's VPN - but not necessarily from other Microsoft's services), the query refreshes just as normal. However, this is not an option that my end-users can implement.
As already mentioned, I made sure that there aren't any kind of imports, connections or references to extrenal sources. And the workbook is in the PC's hardrive as well. I've tried the usual recommendations: disabling background preview, enabling fast data load, etc.. Also, most of the transformations made in the queries are just joins, unions, filters, un/pivots, and adding columns; no transformation that would require external aid so far I'm aware.
Furthermore, this issue happens only to this series of queries. Other files, that do import and transform data from the company's servers, do not present this kind of issue.
Has anyone seen this kind of problem before? Or could happen to have an idea of what is causing it?
All help is greatly appreciated!
Regards.
