Hello All
My financial model is 100mb, it has 50 identical tabs which calculate cashflows monthly for 25 years (so around 350+ columns) and 1000 rows in each tab.
This means it is slow to open, close and to make any changes to the 1 generic template tab, it means i have to copy it again 49 times!
I have been careful not to use any volatile formula, no tables, no conditional formatting, no vba, no links, no named ranges.
The model is for a commercial real estate development. It's difficult to have the data/calculations in another format like a database because it will be used by Excel able only persons, it has calculations in each of those 50 tabs.
What else can i do to increase the efficiency of this file?
Thank you for any helpful suggestions
My financial model is 100mb, it has 50 identical tabs which calculate cashflows monthly for 25 years (so around 350+ columns) and 1000 rows in each tab.
This means it is slow to open, close and to make any changes to the 1 generic template tab, it means i have to copy it again 49 times!
I have been careful not to use any volatile formula, no tables, no conditional formatting, no vba, no links, no named ranges.
The model is for a commercial real estate development. It's difficult to have the data/calculations in another format like a database because it will be used by Excel able only persons, it has calculations in each of those 50 tabs.
What else can i do to increase the efficiency of this file?
Thank you for any helpful suggestions