An error has occurred. Please try again later- while opening the Excel File in the SharePoint Browser

Today I found  one more error while opening the excel sheet.

 i.e.  Error: An error has occurred. Please try again later

 

And  this error will come only once when we open the excel in the first time only, if we try after that we won’t get the same error message but SharePoint event viewer Application and ULS will log the error as below every time after opening the excel file.

 

“There was an error in communicating with Excel Calculation Services http://server /ExcelService*.asmx exception: An error has occurred.[Session: User: SHAREPOINT\system]”

 

 

 SharePoint event viewer application and ULS logs:

 

Error 1:  There was an error in communicating with Excel Calculation Services http://server /ExcelService*.asmx exception: An error has occurred.[Session: User: SHAREPOINT\system]

Event ID: 5240

 

Plan A:

 

Verified the following services and are running correctly:

 

Excel Services are started and running fine.

 

Need to reboot the server.

 

Ref1: http://community.bamboosolutions.com/blogs/sharepoint-2010/archive/2011/09/15/sharepoint-2010-cookbook-sharepoint-2010-excel-services-an-error-has-occurred.aspx

Ref2: http://social.msdn.microsoft.com/Forums/ar-SA/sqlkjpowerpointforsharepoint/thread/5db143b5-0701-4dba-8221-e86bf869984b

 

Plan B:

 

Delete the existing excel service application and need to create the new one and associate the same to the appropriate web apps.

 

Plan C:

 

Verify the Current SharePoint Version and if it is not up to date then  requires a latest service Pack1.

 

http://www.etechplanet.com/blog/fixes-included-in-sharepoint-2010-service-pack-1-%28sp1%29.aspx

 

Error: Excel Services --The user receives the "An Error Has Occurred" message on the server when the TREND, LINEST, LOGEST, or GROWTH are used with external references on the Excel client and then the file is uploaded to the server.

 

Need to execute the plans and will have to cross verify logs .