Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Excel services - Access denied

Posted on 2010-09-08
6
Medium Priority
?
997 Views
Last Modified: 2012-05-10
Having a play with excel services and kpis.
Added a trusted file location and then added a excel web access web part to a new page. No problem.
Now I am trying to create a "kpi list"
I supply the url for the workbook but when I click the button to specify the cells/range and kpi values I get an access denied problem.
The trusted location is a UNC location where domain users have full control.

Sooo I uploaded the document to a document library and put that in my web part, like the other it displays fine.
So I go back to create a kpi list and have exactly the same problem.

What have I missed? I am farm/collection admin and the site creator.
The excel file (both the unc one and the one I uploaded) was created by myself.
ES-error.gif
0
Comment
Question by:QPR
  • 4
  • 2
6 Comments
 
LVL 4

Expert Comment

by:monicai
ID: 33633116
this could be a security issue and even if you have defined your  UNC as trusted location, Sharepoint tries to impersonate and doesn't use  your personal account information to access the UNC.  

Can you check out the following:

1. Go to Central Administration > Application Management > Create or Configure this Farm's Shared Services
2. Go to Excel Services Setting
3. Select File Access Method > Process Account

Process account sets "impersonation" by default.  Select "Process Account" and see how it goes.


0
 
LVL 29

Author Comment

by:QPR
ID: 33633181
I don't see anything about excel services in that area (see image).
If I click through to either of these links I see web app settings but nothing about Excel services.

central-admin.gif
0
 
LVL 29

Author Comment

by:QPR
ID: 33633189
Found where (I think) you meant under SharedServices1
I change it to use the process acount, went back and still got access denied
0
NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

 
LVL 4

Expert Comment

by:monicai
ID: 33633248
are you getting any specific event log and ULS errors related to this issue?
0
 
LVL 29

Author Comment

by:QPR
ID: 33633301
I have this in the windows event viewer for excel calculation services
Failed to load 'http://xxxx/BI/Documents/Weekdays.xlsx' with error: 'The workbook is not in a trusted location.'.
[Session: 22.42eFkhBEsI9sJEN6IIeklK90.5.en-US5.en-NZ73.-0720#0000-04-00-01T03:00:00:0000#+0000#0000-09-00-05T02:00:00:0000#-0060

I have added it as a trusted location and am able to show the spreadsheet in a web part so I'm not sure why it's complaining?
0
 
LVL 29

Accepted Solution

by:
QPR earned 0 total points
ID: 33633321
ok I have it working now, when I added it as a trusted location I pointed directly to the .xlsx file
I created a new trusted file location and pointed it to the document library instead and it is ok now.

If it had to be the library rather than the file then I'd have expected MOSS to complain when I specified the file as the trusted location.

Still can't get the UNC doc to work though and this is set up as
\\server\Development Projects\ExcelTrustedLocation\
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Suggested Courses

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question