In your Workbook_Open event put:
![]()
ActiveWorkbook.RefreshAll Sheets("Starlims").Select ActiveSheet.Range("Table_Query_from_DWH[#All]").RemoveDuplicates Columns:= _ Array(1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, _ 28, 29, 30, 31, 32, 33, 34), Header:=xlYes
Bookmarks