Hi,
I have - Query1 = Excel.CurrentWorkbook()
Below pic shows query properties. How do I refresh this so that only new rows are added. If I manually refresh, the 15,970 rows duplicates giving me 32,000 + rows.
I only want the 15,970 rows plus the new rows.
https://www.dropbox.com/s/dl54ga9hl45biyi/query1.png?dl=0
I have - Query1 = Excel.CurrentWorkbook()
Below pic shows query properties. How do I refresh this so that only new rows are added. If I manually refresh, the 15,970 rows duplicates giving me 32,000 + rows.
I only want the 15,970 rows plus the new rows.
https://www.dropbox.com/s/dl54ga9hl45biyi/query1.png?dl=0