Solved

Excel services - Access denied

Posted on 2010-09-08
6
956 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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

I have just recently built a new SharePoint 2007 farm on a complete Windows 2008 R2 server platform and part of my standard build procedure is to implement a warm up routine, usually in the form of a script that is scheduled every morning to launch …
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…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

770 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