I have created a Pivot Table in Excel that calls a SQL Server stored procedure. It is a very basic sproc that pulls only 3 data columns over, with very small data sets.
When I created this table it ran fine. Every so often however when I refresh the table using date ranges (the only supplied param's) I get a mesage stating that the pivot table did not refresh. Any ideas why? If I run the sproc in sql QA with that date range it runs fine...
Thanks,
SM
When I created this table it ran fine. Every so often however when I refresh the table using date ranges (the only supplied param's) I get a mesage stating that the pivot table did not refresh. Any ideas why? If I run the sproc in sql QA with that date range it runs fine...
Thanks,
SM