Heavy file for calculation and save

[Sameh_Sam]

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.