SOLVED

Excel Query Does not Refresh when File Closed

%3CLINGO-SUB%20id%3D%22lingo-sub-1573242%22%20slang%3D%22en-US%22%3EExcel%20Query%20Does%20not%20Refresh%20when%20File%20Closed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1573242%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EThe%20Excel%20(Excel%202016)%20query%20automatic%20refresh%20does%20not%20refresh%20when%20the%20workbook%20is%20closed.%26nbsp%3B%20It%20does%20when%20it%20is%20open.%26nbsp%3B%20The%20Refresh%20Control%20under%20the%20connection%20Properties%20is%20set%20to%20Refresh%20every%202%20minutes.%26nbsp%3B%20The%20worksheet%20is%20drawing%20data%20from%20another%20workbook%2C%20both%20in%20the%20network%20drive.%26nbsp%3B%20Am%20I%20missing%20a%20setting%3F%26nbsp%3B%20I%20even%20tried%20using%20VBA%20code%20but%20not%20good%20either.%26nbsp%3B%20I%20would%20appreciate%20any%20help%20or%20suggestions.%3C%2FP%3E%3CP%3EThank%20you%20in%20advance.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1573242%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1573451%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Query%20Does%20not%20Refresh%20when%20File%20Closed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1573451%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F752732%22%20target%3D%22_blank%22%3E%40rwmhr%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENothing%20happens%20within%20workbook%20till%20it%20is%20closed.%20You%20may%20use%20PowerShell%20or%20third-party%20utility%20which%20will%20be%20scheduled%20through%20tasks%2C%20when%20work%20it%20opens%20workbook%2C%20refresh%20it%20and%20close%20after%20that.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1573593%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Query%20Does%20not%20Refresh%20when%20File%20Closed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1573593%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20Sergei.%3C%2FP%3E%3CP%3EI%20think%20I%20will%20just%20have%20to%20set%20it%20up%20to%20refresh%20when%20the%20user%20opens%20it.%3C%2FP%3E%3CP%3EThanks.%26nbsp%3B%20Have%20a%20great%20weekend.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello,

The Excel (Excel 2016) query automatic refresh does not refresh when the workbook is closed.  It does when it is open.  The Refresh Control under the connection Properties is set to Refresh every 2 minutes.  The worksheet is drawing data from another workbook, both in the network drive.  Am I missing a setting?  I even tried using VBA code but not good either.  I would appreciate any help or suggestions.

Thank you in advance.  

3 Replies
Best Response confirmed by rwmhr (New Contributor)
Solution

@rwmhr 

Nothing happens within workbook till it is closed. You may use PowerShell or third-party utility which will be scheduled through tasks, when work it opens workbook, refresh it and close after that.

Thank you Sergei.

I think I will just have to set it up to refresh when the user opens it.

Thanks.  Have a great weekend.

@rwmhr 

have a nice weekend too