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
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
Hello, I do not get the Load To option on my menu. Having the same issue, where the Query is updating but the worksheet is not. The original query was to a different .CSV file. I updated the names and paths, and have done multiple 'Close & Load' and Refreshes both in query and on the worksheet.