Forum

Hi Vanessa, Csv.Document([Content]) will automatically split by comma, most probably in the expand table dialog window you see more than 1 column. ...

You cannot stop that behaviour, Power Query tries to identify headers and data type for you, that's why it's adding those 2 steps automatically. The f...

Pivot tables requires to be updated, that is true, but so does Power Query... I can see no difference from this point of view. The Pivot table s...

You might like this article: highlight-selected-cells-in-excel-and-preserve-cell-formatting Another option is to change the layout, from Page Layou...

Hi Will, You don't need to open a ticket, it's just a temporary solution until the file upload on forum will be functional. Received the file, I wi...

It does not have to be active, as long as it's in the same workbook. It might fail only if you have another workbook active, and that one does not hav...

Great, glad to hear you're happy with the solution. Worksheets("Sheet1").UsedRange.Offset(2, 0).ClearContents should work, it does not matter how m...

Hi Will, Welcome to our forum 🙂 Try uploading the file to our Help Desk instead, until the forum will be fully functional: Help Desk

Try uploading the file to our Help Desk instead, until the forum will be fully functional: Help Desk

Ok, I managed to identify the source of errors, it was a data type error, but not where I expected. Here is the codes you can use: Sub ListFil...

I've never heard of this problem before, and I guess it's Traverse related, not Excel. Have you tried pasting as values, not the usual copy paste?

Can you please clarify what do you have in the second table? Or you mean that you need to create a report in a new sheet with sales by salesperson? ...

Hi Blanka, Glad to hear you managed to make it work. Just a minor observation: Can you please mark the relevant answers in this topic? Each mess...

Hi Julian, First, you will have to declare the arguments properly, otherwise they will be considered as Variants: Sub ListMyFiles(mySourcePath A...

Hi Bill, You can build pivot tables from a table produced by a power query (regular pivot tables, not power pivot tables). More, the Group By tool ...