Forum

Table.ColumnNames(Source){0} will return the Name of the first column from the table Source. (Table.ColumnNames returns a list of column ... names) ...

I think it's related to the structure of your file, if you have many formulas and calculation is automatic, things are slow. You can disable calcul...

What's the purpose of the #"Added Custom" step?

You have 2 options: Put an exit if you have exceeded the used range, so your code will not examine 10+million cells: For Each area In Columns("A:J"...

Warren is right, but: For Each area In Columns("A:J").SpecialCells(xlCellTypeBlanks) If area.Cells.Row <= ActiveSheet.UsedRange.Rows.Count Then are...

Normally, you should fix it using a Round function in B column, to 2-3 or more decimal places, a number like 0.000000000000002 will be rounded to 0, e...

Hi Joseph, I was able to complete the refresh without any errors. What excel version are you using?

Hi Julian, It's much more complex than you expect. Please take a look at this article that describes the floating point calculation problem:

Example attached. You can set the csv file path and group size to split into as many pages you need. File size is too large, choose the Open I...

Hi Bill, 1048576 is the maximum number of rows in excel. Obviously, we cannot add in a sheet more that this number of records, so we have to fin...

try this one in cell G5: =IF(G4="Yes","Issue",IF(AND(G$1>0,$E5-SUM($F5:F5)>0),MIN(SUM($G$1:G1)-SUM($F5:F5),$E5-SUM($F5:F5)),0)) It will re...

Hi Aye, You have to take headers separately, remove first 3 columns, then split and sort the numbers as you wish. After you finish sorting, using T...

Thank you I guess a good formula never dies 🙂

Hi, You can automate the download using VBA and Internet Explorer, there is code in this forum to programatically click on a download button, most pro...

Hi, remove On Error Resume Next, this hides the errors from you, but you need to see them to understand what is happening. There is nothing I ca...