SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is there any way to configure the schedule refresh of the PowerPivot file to refresh the file many times per day. even with writing custom code.

Thanks in advance for you support

share|improve this question

To my knowledge SharePoint doesn't allow refreshes of less than 1 day. However there is an additional setting for "as soon as possible" available that refreshes data as soon as resources are available (still starts at the appointed time).

Microsoft has a doc regarding power pivot data refresh available here:

You'll find the info on the ASAP setting on page 7.


After further investigation, there is no programmatic method (no methods or functions in the documented API / Web Services) or other method to set the data refresh schedule with v1 to less than 1 day. MS has not announced any intentions of supporting this feature in a future SP.

share|improve this answer
It may be possible to create a custom timer job that "resets" your job schedule so it gets picked up by the PP scheduling job as a new job to process. Can you please guide me more. this can be done by SharePoint object Model? – m_3ryan Aug 23 '11 at 7:50

SharePoint doesn't allow it, but refactoring the stanadard code you can resolve it. I published a sample code in

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.