I'm having a strange issue with one Power Query in one Excel workbook.
I have a workbook with a number of Power Queries. For one specific query (POReceiptHdr), the Refresh button on the Query contextual tab does nothing.
The query itself works correctly. The following methods all work: Power Query Editor->Refresh Preview, Data->Refresh, Right-click in query table->Refresh, Alt+F5, Ctrl+Alt+F5.
The only thing that fails is selecting the query output table → Query tab → Refresh. Clicking that button produces no error, no status-bar message, and no refresh activity. This is only happening for this one query. Other Power Query output tables in the same workbook refresh normally using the Query tab button, as do other queries in other workbooks.
Excel version Microsoft Excel for Microsoft 365 MSO, Version 2606 Build 16.0.20131.20154 64-bit
Query name: POReceiptHdr
It is loaded to an Excel table. The table name and Load To destination are correct. The query formula is normal and uses an ODBC source:
let
Source = Odbc.DataSource("dsn=#####", [HierarchicalNavigation=true]),
db_name = Source{[Name="#####",Kind="Database"]}[Data],
dbo_Schema = db_name {[Name="dbo",Kind="Schema"]}[Data],
...
What I've already done:
I compared query settings with working queries and they looked the same.
I reset Excel ribbon customizations, which did nothing.
There are no VBA refresh handlers.
I examined the workbook connection — it exists and is valid.
ThisWorkbook.Queries("POReceiptHdr").Formulamatches a duplicated query exactly.
If I duplicate the query (same M code, same source), the duplicate works correctly with Query->Refresh. So it appears to be something about the original query object, not the query logic.
What internal Excel object controls the Query tab Refresh button, and how would I repair/reset the metadata for a single Power Query without deleting/recreating the query? (This is a huge, very interconnected workbook and I don't want to duplicate the query for fear something would break.)