•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Best way to automate data refresh for multiple power queries pulling from web sources?
Ive got a workbook with about 15 power queries pulling data from different web sources. Some need to refresh daily, others weekly. Right now Im just clicking refresh all manually but its getting tedious. I tried setting up a VBA macro to refresh them on open but it slows down startup a ton. Anyone found a solid way to schedule these refreshes or optimize the process? Considering power automate but not sure if its overkill. Curious how others handle this since my data sources are pretty stable at this point.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#generative AI for data analysis
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#rows.com
#Excel compatibility
#financial modeling with spreadsheets
#Excel alternatives
#natural language processing for spreadsheets
#data refresh
#power queries
#VBA macro
#scheduled refreshes