Thanks for the information but I do not use stored procedures and I'm wondering why you feel this is necessary. I base the spreadsheet on specific views and then I allow parameters which I code into the view such as a date field, I use [Enter Date] in the criteria field. This eliminates problems with SQL Server.