•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Excel Power Query refresh suddenly incredibly slow
Hi everyone,
I have a file that I refresh daily with several queries.
One of those became incredibly slow (few seconds to hasn't finished yet) from one day to the next. Nothing changed in the file or source, it is not very large (~5000 lines) and without any manipulations other than changing the data type.
I have tried to change the privacy levels, background refresh, fast load and so on as I found online, but nothing helped. How can I solve this?
Thank you!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#Excel compatibility
#rows.com
#Excel alternatives
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#large dataset processing
#real-time data collaboration
#financial modeling with spreadsheets
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#Excel
#Power Query
#refresh
#slow