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?
[link] [comments]
Want to read more?
Check out the full article on the original site