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
PhilipTreacy Thanks so much! Still learning Power Query
That file is a macro enabled workbook, but there are no macros inn it so you could just save it as a .xlsx
I have my default save type set as .xlm due to using macros alot.
Looking at the 2 queries in the workbook, both are set to Connection Only.
-Where can I see that both queries are set to Connection Only?
-It's strange that it was a Connection Only, but there is a Table to be refreshed..? How did I manage that? lol
(I ask because when I follow your instructions, and try to use Exsisting worksheet, I get an error: Query Results cannot overlap a table or XML mapping. Please select another destination.)