Forum Discussion
Power Query Data is updating in PQ Editor, but not in Excel Table
Hi Anonymous
That file is a macro enabled workbook, but there are no macros inn it so you could just save it as a .xlsx
Looking at the 2 queries in the workbook, both are set to Connection Only. In the worksheet, right click on the query and then Load To
You'll see it'sset to Only create connection
Select Table and then choose to put the table on an Existing worksheet or a New worksheet.
Regards
Phil
Super UserHi Anonymous ,
1) Make sure that the table is loading to a table in Excel. If not (i.e. it says 'Connection only' under Queries and Connections pane), then go back to Power Query Editor, select the query, and choose 'Close & Load to...' from the top left of the Home tab ribbon and select Table.
2) Make sure that you have hit 'Close & Load' from the top left of the Home tab ribbon.
3) If it's still not updating your Excel table, right-click anywhere on the output table and select 'Refresh'.
Pete
BA_Pete PhilipTreacy The data was loaded as a Table, not a 'Connection Only'.
-When I go into the Power Query Editor, the 'Close & Load To' option is greyed-out.
-When I right-click anywhere in the table, 'Refresh' is also greyed-out.
Here is a copy of the file
https://udfinc-my.sharepoint.com/:x:/p/cday/Eeb9AoWu8k9IjLZ5MCNI4FkBa7QBpZSJIlh2Q-OKZ0metQ?e=wjwOG8