Hi,

I have an external connection to a SQL server in Excel 2010. I would like the WHERE clause to allow users to enter the required date. Preferably, I would like this date as a cell reference on the Excel sheet rather than as an input parameter. There does not seem to be any options for paramaters in Connections > Properties. Does anyone know how to do this?

Thanks