I have an excel table in a workbook that is derived via Power Query. A simple table, 13 columns, 400 rows currently.
It shouldn't matter, but for background: This is trading data. It is taken from my trading platform, saved in a text file, brought into the data model via power query, sorted, filtered, and condensed, then loaded to Excel.
I then added two columns. These two columns are both Data Validation from list.
I have added two columns to the table which are Data Validation drop downs from lists.
On a refresh the table loads new data (new rows) and brings the Data Validation with, which is great. However, if I have selected a value in those Data Validation fields for the last row of data, then Refresh and bring in additional rows of data, the previous "last row" loses the Data Validation value, and that value is pasted to the new last row as the value. Nothing special, no error blocking, just referencing two small tables within the workbook.
The data validations work fine. When I refresh the data, new data comes in and populates new rows. The appended data validations are available on the new rows.
However, If I assigned a value to one of these data validation fields the last row of data, then refresh the data adding new rows, the value contained in the previous "last row" of data is cut from that row and pasted into the new "last row's" data validation field.
It appears to be dragging the values down, but also removing them from that previous last row.
Feels like a bug, but I'm wondering if I need a vba work around.
As always, TIA for sharing any insight.
It shouldn't matter, but for background: This is trading data. It is taken from my trading platform, saved in a text file, brought into the data model via power query, sorted, filtered, and condensed, then loaded to Excel.
I then added two columns. These two columns are both Data Validation from list.
I have added two columns to the table which are Data Validation drop downs from lists.
On a refresh the table loads new data (new rows) and brings the Data Validation with, which is great. However, if I have selected a value in those Data Validation fields for the last row of data, then Refresh and bring in additional rows of data, the previous "last row" loses the Data Validation value, and that value is pasted to the new last row as the value. Nothing special, no error blocking, just referencing two small tables within the workbook.
The data validations work fine. When I refresh the data, new data comes in and populates new rows. The appended data validations are available on the new rows.
However, If I assigned a value to one of these data validation fields the last row of data, then refresh the data adding new rows, the value contained in the previous "last row" of data is cut from that row and pasted into the new "last row's" data validation field.
It appears to be dragging the values down, but also removing them from that previous last row.
Feels like a bug, but I'm wondering if I need a vba work around.
As always, TIA for sharing any insight.
