Solved

Excel services - Access denied

Posted on 2010-09-08
6
965 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
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I recently came across an issue with a MOSS 2007 deployment where access into some sub-sites were denied, even for the MOSS farm administrators. A bit of background to the setup of this MOSS farm; this was a three server setup, consisting of a fr…
If you create your solutions on SharePoint sooner or later you will come upon a request to set  permissions of the item depending on some of the item's meta-data - the author, people assigned as approvers, divisions, categories etc. The most natu…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

860 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