I met one problem in SharePoint Designer 2010.
As my customer's requirement, I created a lot of PivotTables and PivotCharts in multiple sheets in one Excel file. Now I need to integrate all the PivotCharts in to one single page, all the PivotTable need to be show on the page at the same time,
so I cannot use the named Item drop-down list.
for this requirement, I inserted a lot of Excel Web Access web parts in the page, all the EWAs connect to the same source file(the Excel file mentioned above) which has already located on SharePoint Server, then I am not able to open the page in
It will show two kinds of information when failed to open the page:
1.It shows: The web page cannot be displayed.
2.The 2nd will show one dialogue asking for user credentials continuously.
Do you have any idea about it, or if you have other methods to make all the PivotChart show on the page simultaneously, please let me know.
View Complete Post