Data Table (suspecting) stuffing up Excel calculations

[Naz555]

Hi Guys and Girls,

I have built a model which has approx 33,000 different combinations (output) based on user selection. There are 15 different options for user selection which gives rise to the number of outputs (2^15 -1) = 32,767.

I have inbuilt a data table that gives the output for all of the 32,767 scenarios. However, it seems like for each change the calculations takes forever and I am not sure when the calculations are complete. Saving takes forever and stuffs up excel. The numbers keep changing in front of my eyes. The file is 10Mb big/small.

Can anyone suggest a workaround? Would breakijng down the data table into smaller tables help?

Cheers,

Naz

[:) Sixthsense :)]

Can you please share the few for our eyes?

[Naz555]

The file itself? Its too clunky it'll get stuffed for sure...

[:) Sixthsense :)]

Not the whole part just 5 to 10 lines of data...