Hello. My Excel 2010 PowerPivot source is a SQL 2008 Stored Procedure. It works great. When I set it up, it prompted me for the parameters. (there are 4 total) I manually entered in the default values for each of the 4 parameters.

Is there a way to changed these parameters from Excel? So any user that has this Excel file open can enter new values in to a field on in an excel worksheet and this value will feed in to the Stored Procedure... then automatically updating the results? I don't want to make the users go in to the code. Would like this to be automated.

Thank you in advance!!