Hello Nilem,

I would attach it but the workbook is just too large. When I put the data from SAP to Excel the workbook's size suddenly changes to about 15-20 mb although there are only 10 sheets in. And that's why it takes so long for the calculations to take place. I guess this is a SAP-Excel issue. I am not sure. I was just wondering whether I could you use the evaluate function in vba to speed up the calculations. For example from A7 till A10000 I want to use the formula above whereas the lookup value changes as we go down the rows. In other words I want to make the calculations out of the sheet (as an array in vba). Is that possible?