•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to copy a query and change one parameter multiple times without the refresh being very slow?
So I have made a query to search a folder that has bank statements (all the same format) and from there populate separate tabs ready to be copied for uploads.
What I did was make one query for one bank account, copy this query and change the account each time for every new tab. It's made the refresh really slow. I'm sure there must be a much more efficient way for excel to do this?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#rows.com
#real-time data collaboration
#real-time collaboration
#query
#Excel
#bank statements
#copy
#refresh
#account
#parameter
#efficiency
#folder
#tabs
#search
#change