T
Timmy Mac1
I have a file which is set up using quite a bit of sumproduct formula.
From a data set the aim is to produce results from different sets o
criteria ordered in accordance to three separate preferences.
So, if the criteria is combinations of a,b and c, and I set m
exclusions accordingly, I then need to produce three separate sets o
results.
What I'm finding is this. I have the Calc setting at manual and i
going between each set of results there is not much delay afte
pressing the Calc button.
However, when I go back to select the criteria, not only does it take
little time before processing the input to the cell and moving to th
next one, but hitting the Calc button produces a long long dela
freezing up all my open spreadsheets. Thereafter, when changing th
results to reflect a different set for that crieria, there is n
problem until I once again seek to change the criteria.
Does anyone have any ideas why this might be
From a data set the aim is to produce results from different sets o
criteria ordered in accordance to three separate preferences.
So, if the criteria is combinations of a,b and c, and I set m
exclusions accordingly, I then need to produce three separate sets o
results.
What I'm finding is this. I have the Calc setting at manual and i
going between each set of results there is not much delay afte
pressing the Calc button.
However, when I go back to select the criteria, not only does it take
little time before processing the input to the cell and moving to th
next one, but hitting the Calc button produces a long long dela
freezing up all my open spreadsheets. Thereafter, when changing th
results to reflect a different set for that crieria, there is n
problem until I once again seek to change the criteria.
Does anyone have any ideas why this might be