PQ Queries won't refresh via VBA or clicking, but will refresh in the table - any ideas?
Our take
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]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Excel - Get Data - Access stuck on "Loading Data..."I have a workbook with multiple queries that pull data from Access queries and load to pivot tables. Most of them update/refresh fine, but several of them just spin and get stuck on "Loading data..." The query results are only like 10-20 rows for each of these that get stuck. The power query does no filtering/sorting or anything, I have no VBA doing anything, no macros, or conditional formatting. I'm clueless as to why some are fine and these others just get stuck. Help!!! TIA. submitted by /u/Good_Struggle_7471 [link] [comments]
- Power Query Refresh TimeI created an Excel file with a Power Query product database. It takes item-level data (sizes, colors, logos, etc.) from an Item Master, expands it into all SKU combinations, and builds out a final product database with pricing and item info. It also pulls in a predetermined product codes from a separate tab with 300,000 rows. When I refresh the file (both at home and at work), it takes about 20 seconds with 50 rows. I had a couple coworkers try the exact same file, and it takes about 2 minutes for them to refresh. It is the same file, same data, same network, and similar computers. I can’t figure out why it’s consistently faster for me than everyone else. Any ideas of what could be causing this? submitted by /u/Presto1985 [link] [comments]