I have a stored procedure in SQL2005 that builds7refreshes a table. I cannot use SQL Views due to highly complex programming that is needed. I have an excel pivot table that uses that table afterwards.
I would like the user to be able to refresh the data in the pivot, including of course running the SQL stored procedure and than refreshing the pivot.
Any ideas would be highly appreciated.
