Heavy file for calculation and save

Dear All,

Please note that I have an issue, which I previously submitted to the forum with the attached file, as the sheet “Summary” is too heavy and I asked for a simplified equation to make the file lighter to calculate and save.

But after adding one of the submitted equation the file is still too heavy and I provided a large scale than the one I submitted before to show the issue (after removing many other sheets with lot of calculations but not with the effect of the sheet “Summary”).

So I’m willing to have any solution to my issue, as I was suggested previously in the forum to use PowerQuery – which I think a very good tool – but I tried to search about it and couldn’t handle it as I have zero experience in PowerQuery.

Any support/guidance will be highly appreciated with equation or any other solution as the data in the file is going bigger every day.

Name of my previous post:
“Extract Month and Year from Date cell which was previously returned by equation”

Thanks & Best Regards for your usual support.

Any update please?

Thank you for your reply and suggestion, I'll try to restructure my file and test again, also I'll try to search for ways to help me with PowerQuery as I never used it before.

I restructured my file, but without using PowerQuery as unfortunately I'm not yet familiar with it, but the new structure allowed me to simplify a lot of things and change used equations which made my file light to use, and I still need to create some reports in the new structure based on the old structure, but I'll search for ways to achieve it.

Thank you for your suggestion and for making my file able to use without spending a lot of time saving and loading the file