Excel cannot connect to the SharePoint list

Excel cannot connect to the SharePoint list

Issue: Cannot connect to the server at this time. Changes to you Data cannot be saved

Solution: Follow the below steps to resolve the issue.

1.    Open Internet Explorer

2.    Go to Tools -> Options then go to Advanced Settings.

3.    Scroll and go to the Security Section.

4.    By default "Check for publisher's certificate revocation" option is checked. Uncheck that and click on OK.

5.    Now close the browser and open the SharePoint site in a new browser window.

 


I hope the above information will help you to resolve the issue, in case of any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

The workbook cannot be opened or we are sorry, we couldn’t open your workbook.

The workbook cannot be opened  or we are sorry, we couldn’t open your workbook.

Issue: We are sorry we could not open your work book or sorry, but to open this workbook your computer must be running a supported version of Microsoft excel

Solutions: there could be many reasons of the issue. I am providing the solution for the  most common.

Error: We are sorry we could not open your work book

 

 

You can use following cmdlets to get this issue resolved

$webApplication = Get-SPWebApplication –Identity <URL of the Web application>

$webApplication.GrantAccessToProcessIdentity("<insert service account>")

Error: We're sorry, we couldn't open your workbook. It is possibly corrupt or using a file format that's not supported. Do you want to try and open this file in excel?" as shown in below image

1.   Download the file to local system and open it in excel. If it does not open correctly then you can say it is  corrupt and need to be changed.

2.   If it opens correctly then nothing is wrong with file, you have to check for other resolution.

·        it might be the reason that  not started Excel web service on all your web front end servers. Once you start the excel web service on all your web front end servers. This issue will be gone

 

I hope the above information will help you to resolve the issue, in case of any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

Failed to download chart or image

Failed to download chart or image

issue: After create chart and upload to site. I got error "failed to download chart or image"

Cause: In Excel Service, there is a file size limit in the configuration. Large graphs may cause this to fail.  By default  is 1MB, so if a chart is bigger than that, it won't render. 

Solution: To solve the issue, Please take steps as below:

1.   Go to central Administration->Application management->manage service applications->Excel services application->Trusted File Locations.

2.   Edit the Trusted File Location, change Maximum Chart or Image Size to 50 and Maximum Concurrent Queries Per Session to 50.

3.   Go to Global Settings, change Memory Cache Threshold to 95

                                     

 

I hope the above information will help you to resolve the issue, in case of any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.

Unable to download Excel services chart

Unable to download Excel services chart

Issue: Unable to download Excel services chart

Resolution: please follow the below steps to resolve the issue

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.

Product applies to:

1)   SharePoint Server 2010

2)   SharePoint Foundation 2010

3)   SharePoint Server 2013

4)   SharePoint Foundation 2013

 

I hope the above information will help you to resolve the issue, in case of any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.