i have to read an excel with 7-10k rows and when i use read range (workbook) is giving me some weird bugs so i use read range with scope (excel) but it takes sooooo long to read actually never ends… what can i do? i have to work with the inner values and sheets…
Here shows in debug mode the real name but the error says another name which is not even in excel. Dont know from where is taking it. if i run a smaller one with this activity this error never happend
i saw surfing in this forum that this is a common bug still unsolved…
TO filter, directly apply macro formula to one dummy excel column by
Write Cell and AUto Fill Range activity. then do filter activity “criteria if no matching column value “#N/A””