If one query references another in same workbook, does refreshing the last step, refresh all

%3CLINGO-SUB%20id%3D%22lingo-sub-2596355%22%20slang%3D%22en-US%22%3EIf%20one%20query%20references%20another%20in%20same%20workbook%2C%20does%20refreshing%20the%20last%20step%2C%20refresh%20all%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2596355%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20built%20a%20query%20that%20pulls%20data%20via%20an%20ODBC%20connection%20(YAP060_PRE).%20I%20then%20added%20a%20Conditional%20Column%20to%20create%20something%20I%20can%20filter.%20This%20query%20(YAP060_PRE)%20was%20then%20loaded%20to%20the%20Data%20Model.%20I%20then%20created%20another%20query%20(YAP060)%20that%20references%20the%20first%20query%20(YAP060_PRE)%20and%20loads%20it%20to%20a%20worksheet.%20What%20I%20want%20to%20be%20able%20to%20do%20is%20Refresh%20YAP060%20and%20it%20refreshes%20YAP060_PRE.%20Is%20it%20already%20doing%20this%20and%20I'm%20just%20not%20aware%2C%20is%20it%20not%20possible%2C%20or%20is%20my%20setup%20wrong%3F%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%22image.png%22%20style%3D%22width%3A%20939px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F299563i2D543FA12CE216E6%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20601px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F299564i924CB011529A19F9%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.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%3EOffice%20365%20ProPlus%2C%20Version%201708%20(Build%208431.2242)%3C%2FP%3E%3CP%3EWindows%2010%20Enterprise%2C%20Version%201909%2C%20OS%20Build%2018363.1679%3C%2FP%3E%3CP%3EProcessor%3A%20Intel(R)%20Core(TM)%20i7-8665U%20CPU%20%40%201.90GHz%202.11%20GHz%3CBR%20%2F%3EInstalled%20RAM%3A%2016.0%20GB%20(15.8%20GB%20usable)%3CBR%20%2F%3ESystem%20type%3A%2064-bit%20operating%20system%2C%20x64-based%20processor%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2596355%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-2596976%22%20slang%3D%22en-US%22%3ERe%3A%20If%20one%20query%20references%20another%20in%20same%20workbook%2C%20does%20refreshing%20the%20last%20step%2C%20refresh%20all%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2596976%22%20slang%3D%22en-US%22%3ECtrl%2BAlt%2BF5%20to%20refresh%20all%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2611507%22%20slang%3D%22en-US%22%3ERe%3A%20If%20one%20query%20references%20another%20in%20same%20workbook%2C%20does%20refreshing%20the%20last%20step%2C%20refresh%20all%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2611507%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1047584%22%20target%3D%22_blank%22%3E%40Yea_So%3C%2FA%3E%26nbsp%3Bi%20thought%20CTRL%2BALT%2BF5%20refreshes%20all%20pivot%20tables.%26nbsp%3Bi'm%20asking%20(1)%20if%20you%20create%20a%20new%20query%20with%20a%20source%20of%20another%20query%20(which%20ODBC%20to%20raw%20data)%2C%20does%20refreshing%20the%20new%20query%20also%20refresh%20the%20referenced%20query%3F%20(2)%20if%20not%2C%20is%20there%20a%20way%20to%20do%20that%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2611597%22%20slang%3D%22en-US%22%3ERe%3A%20If%20one%20query%20references%20another%20in%20same%20workbook%2C%20does%20refreshing%20the%20last%20step%2C%20refresh%20all%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2611597%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1009713%22%20target%3D%22_blank%22%3E%40JoeRodgers2021%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Frefresh-an-external-data-connection-in-excel-1524175f-777a-48fc-8fc7-c8514b984440%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ERefresh%20an%20external%20data%20connection%20in%20Excel%20-%20Excel%20(microsoft.com)%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have built a query that pulls data via an ODBC connection (YAP060_PRE). I then added a Conditional Column to create something I can filter. This query (YAP060_PRE) was then loaded to the Data Model. I then created another query (YAP060) that references the first query (YAP060_PRE) and loads it to a worksheet. What I want to be able to do is Refresh YAP060 and it refreshes YAP060_PRE. Is it already doing this and I'm just not aware, is it not possible, or is my setup wrong?

 

image.pngimage.png

 

 

Office 365 ProPlus, Version 1708 (Build 8431.2242)

Windows 10 Enterprise, Version 1909, OS Build 18363.1679

Processor: Intel(R) Core(TM) i7-8665U CPU @ 1.90GHz 2.11 GHz
Installed RAM: 16.0 GB (15.8 GB usable)
System type: 64-bit operating system, x64-based processor

3 Replies

@Yea_So i thought CTRL+ALT+F5 refreshes all pivot tables. i'm asking (1) if you create a new query with a source of another query (which ODBC to raw data), does refreshing the new query also refresh the referenced query? (2) if not, is there a way to do that?