Dear All,

I have the excel file with total amount row is 4632 rows, and the blank is around 4000 rows. But When i deleted the blank row, the time take nearly 10 minutes, then i licked and it show not responding. And one of my user said that when they used office 2016, it is ok to do that. But when we are changing to 365, it happened.

Does any one have any good solution to easy to manage this one.

Thanks