Forum

Philip Treacy
Philip Treacy
@philipt
Admin
Member
Joined: Oct 5, 2010
Last seen: Jun 6, 2026
Topics: 61 / Replies: 1588
Reply
RE: Power query loading multiple pdf files from a folder

Hi Gary, The issue isn't that there are multiple PDF's, it's the structure in the PDF's differs. You'd have the same issue with workbooks, tables,...

4 years ago
Forum
Reply
RE: Open folders on a network using VBA

Hi Michael, Your IT Dept really should know better than to use characters like # in folder names. Can you ask them to change it? Or, can you ma...

4 years ago
Forum
Reply
RE: Extracting URL from the Webpage from multiple HTML tables

Hi Ritabrata, Html.Table only works in PBI and it requires a CSS selector to get the data from the web page. The tables on that GitHub page have n...

4 years ago
Forum
Reply
RE: How to Remove Rich Format Text from Multiple Cells

Hi Katie, Have you tried using the Format Painter in the Ribbon to copy/paste formatting from an unformatted cell over the rich text formatted cell...

4 years ago
Reply
RE: Open folders on a network using VBA

Hi Michael, It doesn't like the # in the folder name. It's not advised to use characters like # in file or folder names, can you change it? Reg...

4 years ago
Forum
Reply
RE: Vba for logistic

Hi Neda, You can use Loom to record your screen and host the video then link to it from here. If we hosted everyone's videos we'd run out of disk ...

4 years ago
Forum
Reply
RE: Get ALL Entries from a Webpage

Hi Matthias, The behaviour you describe from the webpage indicates that the loading of new data is triggered by scrolling to the bottom of the page...

4 years ago
Forum
Reply
RE: Get ALL Entries from a Webpage

Hi Matthias, PQ can't interact with a website in this way. You could use Power Automate though. You can start a browser, then send the END key ...

4 years ago
Forum
Reply
RE: How can I format the time and keep them consistent (while refreshing) on a table or on a Power Pivot table?

Jim, No file is attached. Please follow the instructions here to upload a file Read This First | Forum Rules and Guides | Excel Forum • My On...

4 years ago
Forum
Reply
RE: Row data getting mixed up after expanding a merged query

Hi Mike, data in PQ isn't stored in a consistent state - that is, the view you see of the data and the way PQ is actually storing it, isn't necessa...

4 years ago
Forum
Reply
RE: Power query - expanded column contains Table

Hi Tina, Can you please supply the XML? Without this it's hard to give you anything other than general guidance. When you have a column full of...

4 years ago
Forum
Topic
Forum
Replies: 4
Views: 1272
Reply
RE: How to remove different headers in power query

Hi Venkata, Please supply some sample data showing the way the data and headers are mixed in your table following import by PQ. Without this it'...

4 years ago
Forum
Reply
RE: adapt Display-All-Matches-from-Search-in-Userform-ListBox code into my macro

Hi Hassanin, Please supply a file with some sample data, showing the exact column names and layout you will be using. Without this any code that i...

4 years ago
Forum
Reply
RE: Pivot Query

Nothing attached. Click the Start Upload button after selecting the file(s).

4 years ago
Page 17 / 110
0