Upon upgrading from Sharepoint 2010 to 2013, we encountered the following behavior for setting an automatic refresh for powerpivot sheets:

When an auto refresh was set, and a new version of the same document was uploaded, the auto refresh fails. It does not even show the refresh history page, but just the page where you can enable one.

Upon enabling a new auto refresh, the history page shows up, and now it does display the latest refreshes (including the one that failed with the error Could not find the schedule for this work item).

Hi,

Base on the description, you set an automatic refresh for powerpivot sheets, but the auto refresh failed with the error Could not find the schedule for this work item.

I suggest as following:

1. Check whether set up PowerPivot Data Refresh correctly.
2. Setup a new schedule.
3. Contact the schedule owner and ask him or her to recreate the schedule.
4. Check whether upgrade PowerPivot workbooks correctly.
5. Collect the log information for further investigation.

More information:

PowerPivot Data Refresh: http://msdn.microsoft.com/en-us/library/ee210679.aspx

Upgrade Workbooks and Scheduled Data Refresh: http://msdn.microsoft.com/en-us/library/jj218794.aspx

Configure and View SharePoint Log Files and Diagnostic Logging (PowerPivot for SharePoint): http://technet.microsoft.com/en-us/library/ee210652.aspx

Troubleshooting PowerPivot Data Refresh: http://social.technet.microsoft.com/wiki/contents/articles/3870.troubleshooting-powerpivot-data-refresh.aspx

If still no help, for quick and accurate answers to your questions, I recommend you to initial a new thread in  SQL server forum.

SQL server forum: http://social.technet.microsoft.com/Forums/en-US/home?category=sqlserver

Best Regards,

Linda Li

I suggest as following:

1. Check whether set up PowerPivot Data Refresh correctly.
2. Setup a new schedule.
3. Contact the schedule owner and ask him or her to recreate the schedule.
4. Check whether upgrade PowerPivot workbooks correctly.
5. Collect the log information for further investigation.

Thank you very much for you answer. In answer to your suggestions:

1. Yes: it works correctly until we upload a new version of a document
2. We have to do that, but that's the problem: we have over 200 documents which are updated with new graphics and/or tables on a regular basis at the moment. We need to retain the refresh schedule, otherwise we need to set a refresh for 200+ docs every other week. And this number is growing
3. N/a
4. They did upgrade correctly: everything is working fine otherwise
5. We cannot find anything usefull in the logs, but I will post them for future reference

Do you have any other idea's?

Thank you very much in advance,

Jasper Kock

Hi,

First, I suggest you to verify Data Refresh. Please see: http://technet.microsoft.com/en-us/library/ee210651.aspx#drverify

Then if you are using Excel as a data source, PowerPivot in SharePoint will not auto update your information, you can try this solution:

http://powerpivotgeek.com/2010/08/18/working-with-the-2010-office-ace-provider/

If still no help, for quick and accurate answers to your questions, I recommend you to initial a new thread in  SQL server forum.

SQL server forum-> SQL Server PowerPivot for SharePoint: http://social.msdn.microsoft.com/Forums/en-US/home?forum=sqlkjpowerpointforsharepoint

Best Regards,

Linda Li

• Marked as answer by LindaliMicrosoft contingent staff, Moderator Friday, August 23, 2013 9:04 AM

Hi,

First, I suggest you to verify Data Refresh. Please see: http://technet.microsoft.com/en-us/library/ee210651.aspx#drverify

Then if you are using Excel as a data source, PowerPivot in SharePoint will not auto update your information, you can try this solution:

http://powerpivotgeek.com/2010/08/18/working-with-the-2010-office-ace-provider/

If still no help, for quick and accurate answers to your questions, I recommend you to initial a new thread in  SQL server forum.

SQL server forum-> SQL Server PowerPivot for SharePoint: http://social.msdn.microsoft.com/Forums/en-US/home?forum=sqlkjpowerpointforsharepoint

Best Regards,

Linda Li

• Marked as answer by LindaliMicrosoft contingent staff, Moderator Friday, August 23, 2013 9:04 AM

Were you able to solve this issue?

Not yet.

As a solution we created our own refresher and push the refreshed files to SharePoint