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

PQ Queries won't refresh via VBA or clicking, but will refresh in the table - any ideas?

My workbook has 4 queries:

Active Proposals is a SQL pull from our db

Then there are three queries that reference that list, for Funded/Asked/Changed this month.

I have a VBA script that refreshes all four of them, literally just four lines of connections.refresh.

Sub RefreshProposalLists() ThisWorkbook.Connections("Query - ActiveProposals").Refresh ThisWorkbook.Connections("Query - Funded This Month").Refresh ThisWorkbook.Connections("Query - Asked This Month").Refresh ThisWorkbook.Connections("Query - Changed This Month").Refresh End Sub 

Two of them work, and two don't. Like, when I F8 through the sub, Active proposals refreshes, Funded and Asked do nothing (but also don't error), and then Changed refreshes.

In Queries & Connections, they also don't respond when I right click on them and choose Refresh, or click on the Refresh icon.

But here's the kicker: if I go to the Funded or Asked tables and right click and choose refresh , they refresh like normal.

Any idea what might be going on here?

submitted by /u/pookypocky
[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
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#no-code spreadsheet solutions
#Excel alternatives
#PQ Queries
#VBA
#refresh
#Active Proposals
#SQL
#connections.refresh
#Workbook
#queries
#Funded
#Asked
#Changed
#Tables
#Queries & Connections