Slow Calculation

[Excel777]

Hi
I am working with large excel file which over 40 MB, it takes about 5 minutes in calculations and getting final results any idea or trick to make it work faster it's very boring for me wish any can help.
I use Office 2019
Thanks

 

[number kruncher]

Processing power and memory are all factors in the speed, however..

Are there Data Tables which can be held in the 'Data Model' rather than on Tabs, and only bring the information relevant from the 'Data Model' with the use of Pivot Tables.

Are you bringing to much Data into the Model, can you use Power Query to Transform the Data prior to importing it, to give yourself a reduced size data set?

Are you 'dirtying' cells which are not being used, make sure Rows and Columns, below and to the right of your 'used cells' is clean.

etc..

I hope this helps

NK

 

[Excel777]

Cells not clean it have conditional formats

no I can't use pivot table because it depending on multi different types of array formulas

 

[number kruncher]

Conditional formatting is fine, as long as used only on the cells intended. Make sure the Applied area is targeted at your intended cells, not whole columns or rows.