Forum

Hi David, You need to be specific about what the problem actually is. When you say 'can not be used any more' - why? Are you getting an error? ...

Hi Nati, Can you please explain what it is you are actually trying to do. Why are you exporting data from Excel to Word? There might be a better ...

Hi Agal, I presume you want a scatter chart? Enter your data and create the chart, then select an axis and right-click -> Format Axis. The...

Hi Jacek, Are we talking about tables in Excel workbooks? As Anders said, you should use Get files from folder in Power Query. What's the goa...

Hi Martin, You can write a query to create a "temp table" in PQ, but if you are doing this in Excel, the query will load the data from SQL every ti...

Hi Hannu, Please post your most up to date code, so I can see where you are up to. regards Phil

Hi Jospeh, The "table table-striped table-sortable roster" is the CSS class for the table and isn't guaranteed to be unique. The ID of an element ...

Hi Jacek, Yes, just double click the name on the left hand side of the PQ editor and type in the new name. Or, click the query name on the left ...

Hi Kalin, Is it worth learning? Depends on whether or not you will use it. If you are doing work that requires reporting and analysis then yes you...

Hi Martin, I understand the purpose of the ##TEMP table in SQL Server but are you sure it is necessary to create one in PQ? I obviously don't kn...

Hi Hannu, You'll have to be more specific as I don't understand enough about the problem. Please include a link to the site you are trying to ac...

Hi Robb, I used helper columns because I felt it was easier to split the text string (1,2,3) up in the sheet and then feed that into the array form...

Hi Helen, Nothing in the code jumps out at me but I don't know what values the various ListCounts take. If they are very large for some reason that...

Hi Armando, I'd just use SUBSTITUTE str = WorksheetFunction.Substitute(Range("A1"), ". ", ". 0") where your title is in A1. Regards Phi...