Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.


A user logged into SharePoint 2010 (or later) uploads a PowerPivot workbook and chooses to schedule a data refresh for the workbook according to How to: Schedule PowerPivot workbook data refresh

Reference Step 7, choice C: The user enters a known existing Secure Store Target application ID in the Credentials section inside the "Connect using the credentials saved in Secure Store Service" field.

When the user clicks OK to save the schedule, the following error displays:

"The provided Secure Store target application is either incorrectly configured or does not exist"


PowerPivot uses SharePoint's Secure Store methods to verify the user Administrative rights in Secure Store. The method used to check user permissions requires the user have at least one of these Secure Store Administrator rights before the Secure Store Target Application ID is acknowledged: Create, Manage, or Delete Secure Store Application.


Grant the user permissions using the Secure Store Administrators feature in Central Administration.

In Central Administration browse to Application Management
Click Manage Service Applications
Click to the right of the Secure Store Application link so the row appears highlighted.
Click on the Administrators button and add the user attempting to edit the PowerPivot data refresh schedule (or an appropriate security group including user) to the field.  
Click Add, then check "Manage target applications".
Click OK

Finally, add the user to the Administrators group of the Secure Store target application you wish to use for the PowerPivot scheduled refresh. Refer to Step 11. in the "Create a target application" section:

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!