Hi,

Can you give more details?

Which sheet is not properly formatted?

Hi,

In practice file pq_3.02, i was practicing "multiple worksheets not formatted in a table or named range" . once its combined in the new sheet, i change few data in the tables and hit refresh. I noticed that data were not updated in the combined query. my question is why is that?

Hi,

Make sure you do the changes in the file indicated in the query: 'C:UsersAdminDocumentsonline Training HubPractice Filespq_3.02.xlsx', save the changes.

Noticed that you did a query in the first file you uploaded: Worksheets-Not-Correctly-Formatted.xlsx, pointing to the file I mentioned above.

The problem is the file Worksheets-Not-Correctly-Formatted.xlsx with the query has the same data as the pq_3.02.xlsx file, if you make any changes in Worksheets-Not-Correctly-Formatted.xlsx, the query will obviously not load your changes, because it looks into pq_3.02.xlsx, not into Worksheets-Not-Correctly-Formatted.xlsx.

Looks like a simple confusion to me, you should build the query in a new blank workbook, not in a copy of the source file.

thank you i got it.