•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
I have a power query in sharepoint that consolidates all a folder with many other excel files. How do i make it such that it refreshes automatically without opening it?
hi all, as my title states. the total rows adds up to around 100k , up to 500k by the end of the year. it takea me roughly 5 to 10 mins for the power query to fresh the entire dataset manually each time.
This consolidated file is also used my many others.
Hence i was wondering if i can have it auto refreshed lets say first thing in the morning.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#natural language processing for spreadsheets
#generative AI for data analysis
#large dataset processing
#real-time data collaboration
#real-time collaboration
#financial modeling with spreadsheets
#power query
#sharepoint
#excel files
#refreshes automatically
#auto refreshed
#consolidates
#consolidated file
#dataset
#automation
#rows