I was getting this error from 3-4 days, and it was becoming frustrating, since the error is resolved I want to share my experience with all of you. The error from ULS log is-
1. From ULS log the error is - w3wp.exe (0x1EC0) 0x21B4 SharePoint Server Logging Correlation Data xmnv Medium Result=Id=OpenWorkbookAccessDenied; Microsoft.Office.Excel.Server.CalculationServer.FileOpenException: You do not have permissions to open this file. ---> Microsoft.Office.Excel.Server.Host.HostFileException at Microsoft.Office.Excel.Server.MossHost.MossHostFileLoader.GetSPFile(IClaimsIdentity claimsIdentity) at Microsoft.Office.Excel.Server.MossHost.MossHostFileLoader.CheckForPermissions(IClaimsIdentity claimsIdentity) at Microsoft.Office.Excel.Server.MossHost.MossHostHelperMethods.<>c__DisplayClass4.
b__2() at Microsoft.Office.Excel.Server.MossHost.MossHostHelperMethods.WithEnsureClaimsIdentitySetOnThread(IClaimsIdentity claimsIdentity, MethodToRun action)
- In my case ClaimsToWindows was set correctly,
- file was under trusted file location
- App Pool account was added as owner in comtentDB
IIS authentication settings :) The site and sharePoint web services both should run with "Windows Authentication" and it was resolved.
Some times we miss very simple point and that hurts badly :)