Solved

Excel services - Access denied

Posted on 2010-09-08
6
948 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
server program files 24 49
SharePoint 2013 Business Data Connectivity Services questions 7 34
VBA in SharePoint 3 39
Sharepoint 2013 won't open, even in safe mode 26 85
Work Over Net is a new and very powerful collaboration product. With its new easy interface it is becoming very competitive to other similar products like webex and office interactive. WON 2010 have the standard business tools needed for multi-offic…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

920 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now