Hi,
I have put more numer of SUMPRODUCT functions which are refers to the second sheet in such a way that, if i change my project data in second sheet, it automatically updates in my first sheet.
It takes more than 30 to 45 mins to calculate, and sometimes it crashes. What can I do to reduce the time for it to calculate?
I've tried the turning off the calculate automatically option, but still when it's refresehed or saved, the problem comes back.
When i tried with turning ON the calculate manually option, everytime i update my second sheet i have to manually update the cell in the first sheet, in which it supposed to update automatically. and it does not update the first sheet while saving or refreshing also.
Any suggestions? Thanks a lot!!
I have put more numer of SUMPRODUCT functions which are refers to the second sheet in such a way that, if i change my project data in second sheet, it automatically updates in my first sheet.
It takes more than 30 to 45 mins to calculate, and sometimes it crashes. What can I do to reduce the time for it to calculate?
I've tried the turning off the calculate automatically option, but still when it's refresehed or saved, the problem comes back.
When i tried with turning ON the calculate manually option, everytime i update my second sheet i have to manually update the cell in the first sheet, in which it supposed to update automatically. and it does not update the first sheet while saving or refreshing also.
Any suggestions? Thanks a lot!!