Solved

Excel services - Access denied

Posted on 2010-09-08
6
974 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Suggested Solutions

Last week I faced a strange issue recently, i have deployed SharePoint 2003 servers for one project and one of the requirements was to open SharePoint site from same server. when i was trying to open site from the same server i was getting authentic…
The Scenario: Let’s say you have a quote worksheet in Excel that you use to work up sales figures and such for your clients. You utilize SharePoint to manage and keep track of these documents. You would like values from your worksheet to populate Sh…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

730 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