Is there something similar to UsedRange property of Microsoft.Office.Interop.Excel.Worksheet that only loops through the range that contains an active value e.g. cell is not empty?
Now it loops through all the cells that have been modified in any way in the past and it is taking too much time.