I created a large file which acts as a master database, which holds some helper columns with calculations (12Mb). When I activate the calculation manually, it takes ages until completed. It starts by jumping to about 82% and then it stops for more than 10 minutes. I have tried to follow advice I found online, but have not been able to solve this issue. My question is twofold: 1° how can I check what is slowing down the calculation and 2° is there an alternative to OFFSET. I am using =IF(OFFSET(C13;-1
="";"";OFFSET(C13;-1) instead of =IF(B12="";"";B12) because the latter was returning inconsistent formulas when inserting copied rows in a range.
Thanks for your advice.
="";"";OFFSET(C13;-1) instead of =IF(B12="";"";B12) because the latter was returning inconsistent formulas when inserting copied rows in a range.Thanks for your advice.
