Oct 26 2020 03:06 AM
I have made a calculation in a column of a table, this works fine as a start, but after refreshing the data the formula stops after 3500 rows, instead to the end of the table which contains 6000 rows.
Calculation is on automatic, proces is that I retrieve data out of a folder via power query, this creates a table in excel were I add some calculation too, in extra columns. At setup this works fine but after using different data the calculation in the added columns stops at a row of the previous data set.
So it looks like that the table format stops at the old set, but if I enter a simple formula like cel =1 this calculations is processed until the end of the new table.
best regards
Mark
Looking forward for an answer
Oct 26 2020 03:30 AM
Column added to the table returned by Power Query is not in sync with the table, they live independently. Perhaps that's the reason. Perhaps something else, without the file it's hard to say.
Oct 26 2020 03:39 AM
Sorry, I wasn't able to reproduce the fault. Even when I removed columns from the source data as well as adding rows (needed to repair the query), the formula propagated throughout the additional column flawlessly. Maybe submit the sheet to MS with a 'frown'?
Oct 26 2020 03:44 AM
We seem to have given conflicting answers. Mine is not based on any theoretical knowledge, it is just something I have tried a couple of time to see what happens. I was pleasantly surprised, but maybe I was just lucky.
Oct 26 2020 03:52 AM
@Sergei Baklan thks for your response
added a sub set of the file the problem occurs in the column unit seq number made, formule is to add an seq number. this formula works fine upto row 3491 there after it stops.
The columns marked as blue header are added extra.
hope this will help