Forum Discussion

hk2020's avatar
hk2020
Copper Contributor
Sep 23, 2020

All Excel files start refreshing data (powerquery) on opening a new file

I have an issue with my Excel. it is refreshing all open files (with powerquery queries) whenever I open a new file. Pleas help with a solution to this.

 

 

 

 

BI & Data Analysis
excel

4 Replies

    • hk2020's avatar
      hk2020
      Copper Contributor
      Apr 06, 2021
      Sergei, please help. I have almost stopped using Excel power query because of this issue.
      • hk2020's avatar
        hk2020
        Copper Contributor
        Oct 03, 2020
        In the past I had one file that had the setting to refresh on open and I disabled that. I don't know why Excel got corrupted and now it refreshes every open file when i open a new file. If i have 4 files open then it will start refreshing all 4 files when I open a new file.

Resources