Forum Discussion
Converting dynamic array formula to VBA version?
I realize this is late but this might be helpful to someone coming across this discussion.
Have you tried making these bolded references specific and not looking at entire columns? I think those might be responsible for the calculation crunch.
=XLOOKUP(C1#&ROUND(A4:A148,5),'All Activity'!A:A&ROUND('All Activity'!B:B,5),'All Activity'!C:C,"")
Patrick2788 makes a great point and I would add to that:
a) I would format the data on the 'All Activity' sheet as a Table so that the reference can use a Table reference which will automatically expand with added data rows without the need to reference the whole column (e.g. Table1[colA] would reference the column called colA in the table called Table1)
b) I would add a column in that table to do the A:A&ROUND(B:B,5) calculation. When you append the data set it won't have to calculate all the prior rows