I have a choice filter web part where in I have months like Jan,Feb,Mar etc and a excel web access web part.
The choices in the filter web part should determine the URL of the workbook for the excel web access web part.
In the filter web part I gave the choices as Jan;http://sitename:port/ExcelList/MyExcel.xlsx where "ExcelList" is the library that stores the excel files for each of the months. But the excel web part always says that "The file selected couldnt
not be found".
Is it possible for me to know the actual URL getting passed to the excel web access web part?
Pl suggest if there is a better way to do this.
View Complete Post