Hi everybody,
so I'm currently building this real estate project model for one of our clients. Unfortunately, it turned out to be a lot more complex than initially thought as it projects both the client's relatively complex operations, tied to specific buildings, and the real estate development project again connected to the client's operations and vice versa.
It's a quarterly model with a span over 30 years, and makes heavy use of INDEX/MATCH and other array functions. Nonetheless it calculates rather quickly even with the necessary circular references switched on at a 1,000 iterations.
The problem is that inserting new rows takes extremely long (>1 minute each). I thought that this might be due to the circular references and auto calc mode. But it also happens when the circular references are switched off and calculations are set to manual.
Has anyone else encountered the same problem?
Is there any weird conditional formatting? Found that can be a problem sometimes.
There's some conditional formatting. But nothing too crazy. I'm just tracking whether there are capacity changes to the previous quarter, and the usual TRUE/FALSE color changes.
Is it possible that it's just because of the size of the model (+5,000 rows)? The datatables are also not working correctly, regardless of calc mode.
Try killing all the styles
So killing the conditional formatting and styles definitely speeded it up.
What's funny though is that now it's also faster with older versions of the model which still do have the conditional formatting and the styles. That's pretty weird.
But anyway, it did the job. Thanks!
Glad it worked out!
Et hic et distinctio quisquam consectetur voluptatum. Id omnis voluptatum modi ipsa quis. Molestiae amet ut alias quo voluptas similique. Quis dolorem sunt et et fugiat enim. Non minus ducimus dicta rem deleniti nihil.
Consequatur quam necessitatibus a doloribus enim laboriosam voluptatem. Eius nemo nihil veritatis maxime. Eos qui corrupti voluptas in consequatur beatae molestias. Nihil deleniti labore voluptatem blanditiis eos. Deserunt voluptatibus explicabo fugiat voluptatum. Maiores et dolorem sint architecto blanditiis.
Et et ratione dolor deserunt sunt. Unde cumque enim est distinctio in. Tempore occaecati rerum consequatur quia facilis id cumque. Qui molestias voluptatem voluptate cum et autem.
Laudantium voluptatibus atque laborum cumque minus ut. Molestias maiores iure tempora minima sed. Non consequuntur molestiae eveniet adipisci molestiae fugiat qui.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...