Playing
with excel is day to day task! Excel services and its errors are full of excitement
:)
Today
we got one ticket that user is facing some problem while displaying excel
document by means of excel web access webpart. Further probing, we came to know
that he is trying to display some chart by means EWA and getting the error as
mentioned below:
Failed to download Excel Services chart
There
is no need to troubleshoot this error we have a predefined setting in the
central administration so easy resolution!
Let
me describe step by step so that there would be no confusion.
Resolution:
1) Open
the Central Administration
2) Manage
service applications
3) Excel
service application
4) Click
on it
5) Manage
trusted file location settings
6) Click
on the trusted location of that web application
7) In
the Workbook Properties section, there is a "Maximum Chart Size"
setting that is "1" (meaning the maximum chart size is 1MB) by
default.
8) Increase
that and then click OK.
That’s
it, you are done! Check the site on which you were facing the problem and that
should be resolved now.
In case of any queries/questions then please let me know. I
would be more than happy to help you as well as resolves your issues, Thank
you.
Product applies to:
1) SharePoint
Server 2010
2) SharePoint
Foundation 2010
3) SharePoint
Server 2013
4) SharePoint
Foundation 2013
