Forum Discussion
Solved
Power Query Opens Source Workbook on Refresh
Hi, I have been experiencing an issue that when I refresh the query it opens the source workbook that it is refrencing. When I close the workbook it opens it again and again and again. It contin...
- I believe it was short lived bug.
No, but that was somehow tied to that specific workbook. After creating a new one and put the plain data from the old one into it, it worked fine. So, thats some setting in the workbook i guess.
And, not sure if this matters or not: that "problematic" workbook came from the asian side of the world whereas i am located in Europe.
Yeah i pondered this, but it forms part of a complicated web of files which a lot of the business uses to 'run the business'. I'm also planning to move it to PowerBI soon™, so reluctant to change if i can avoid.
Thanks, i'll see if the user can deal with it for the mean time.