1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Is there a more time efficient refresh all than this?

I used to use thisworkbook.refreshall but unfortunately, for whatever reason, it does not refresh my table that is connected to a query. So while, even though the refresh to the query was updated, the table itself does not reflect that update unless i right click and click refresh all..

The code below fortunately helps, but it takes 15 to 20 seconds faster than if i had just clicked right clicked the table and clicked refresh. Normally i wouldn't mind doing this, but i'm trying to make this workbook as painfree as possible for people in case they don't forget any steps:

What is it about this query below that makes it actually updates my data table instead of thisworkbook.refreshall? Any superior/faster method? thank you in advance..

Sub RefreshEverything()

Application.ScreenUpdating = False

ThisWorkbook.RefreshAll

Application.CalculateUntilAsyncQueriesDone

DoEvents

Application.ScreenUpdating = True

End Sub

submitted by /u/ThrowRA_CarlJung
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#natural language processing for spreadsheets
#rows.com
#real-time data collaboration
#big data management in spreadsheets
#conversational data analysis
#Excel compatibility
#intelligent data visualization
#no-code spreadsheet solutions
#data visualization tools
#enterprise data management
#big data performance
#Excel alternatives
#data analysis tools
#data cleaning solutions
#real-time collaboration
#thisworkbook.refreshall
#query
#refresh