As far as I am aware I have not managed to hit a limit and have not heard of a limit on the number of parameters.
What is it that you are trying to achieve.
If you are asking for a max parameter amount I have a feeling you are trying to achieve something complicated and there may be an easier way around this
Thanks for your reply Norat.
Actually we are trying to perform a what-if analysis for one of our dimensions with around 200 possible values..for each of these values we want to allow the user to change its cost and see its corresponding effect..
So trying to find a method without using these many parameters .
Is there a sample workbook you can share
with dummy data if the data is confidential and I can look into this.
How many of the 200 possible values need to be changed at 1 time?