Last seen: Dec 22, 2025
Hi Digalo, You can use a user defined function in Power Query, to combine data from a list of URL's. First, your file from Google sheets must be...
Cloud 365 refers to Office 365, I think the files are used on desktop Excel, not in Excel Online, let me know if i'm wrong. Which is the file size?...
Hi, Without seeing the file, we cannot see what's the problem. You have to check if there are unprintable chars in your data. You can try the Clean...
If you choose Power Query to import data, and you make changes to the table produced by Power Query, that table will be updated when you refresh the q...
Great, glad to hear you managed to make it work, and thank you for your feedback, it's good to know which was the real source of the problem.
Hi Chad, If you're using a 64 bit operating system, and office is in the 32 bit version, if you get the Out of Memory error, or "Excel cannot comple...
DigaloGuapo said ... I can select the URL which will then automatically create a new query. Only Excel 2016 has the vba library objects to create a ...
You will get a quote by mail if you request one. As you already know, you can hire people with 2-3 usd per hour, but if you want to get help from Chip...
Hi, Because each link can potentially have a totally different structure, most probably they need to be processed with different Queries, each with...
You're not showing the most important part: how did you used the table as a parameter in Power Query? That is the source of error, but can't tell you...
Hi Fabiana, You have a report about the source of errors, look into that report and you will be able to see in what column there are errors. Click ...
Hi Ewan, It's in Home tab, but in the Reduce Rows section, under Remove Rows, there are many Remove options, including Remove Errors.
Hi Harry, There are many ways to perform a google search from excel. You can use Query tables, to get the results into a sheet, then follow the ...
Hi Christopher, That should be done more easier with a macro, written according to a clear set of conditions. There may be a formula solution, but ...
Sounds good, glad to hear that you managed to solve it, looks like a good option.