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.