Excel Parameter from Drop down

I have a datasource that poplulates my sheet from sql server. There is a parameter to refresh the 开发者_StackOverflow中文版data. Can I have the choices come from a drop down menu on another sheet? I know no VBA BTW.

---

I know this is a old but the answer is No.

To add dynmic parameters, you need to use VBA.

Its not hard. Since this queistion is 4 months old you have probably already figured that out.