I have created UDF which takes parameters and returns data from the SQL back end. On the data returned to excel, i have created a pivot table and pivot chart. When i pass
in the parameter from excel web acess, the data in the pivot table and chart dosent gets refreshed until i click on "Refresh All Connection" in excel web access webpart.
Is it possible to refresh the pivot table automatically wheh i pass in the parameters from excel web access webpart?
View Complete Post