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

%3CLINGO-SUB%20id%3D%22lingo-sub-1700555%22%20slang%3D%22en-US%22%3EExcel%20files%20refreshing%20data%20on%20file%20open%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1700555%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20issue%20with%20my%20Excel.%20it%20is%20refreshing%20all%20open%20files%20(with%20pwoerquery%20queries)%20whenever%20I%20open%20a%20new%20file.%20Pleas%20help%20with%20a%20solution%20to%20this.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22hk2020_1-1600819935152.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F221291iD82B2F16F6EA3B44%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22hk2020_1-1600819935152.png%22%20alt%3D%22hk2020_1-1600819935152.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22hk2020_0-1600819919142.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F221290i34667218D92AA1AE%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22hk2020_0-1600819919142.png%22%20alt%3D%22hk2020_0-1600819919142.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1700555%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1704979%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20files%20refreshing%20data%20on%20file%20open%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1704979%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F804412%22%20target%3D%22_blank%22%3E%40hk2020%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20check%20query%20properties%20if%20refresh%20on%20opening%20is%20not%20checked.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20465px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F221604i596BB946005BEB2D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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.

hk2020_1-1600819935152.png

 

hk2020_0-1600819919142.png

 

 

 

4 Replies

@hk2020 

Please check query properties if refresh on opening is not checked.

image.png

@Sergei Baklan 

Yes I have checked that multiple times. Its not enabled.

 

hk2020_0-1601685199784.png

 

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.
Sergei, please help. I have almost stopped using Excel power query because of this issue.