PowerPivot Error: could not find the schedule for this work item

Error: could not find the schedule for this work book

There is a fix from Microsoft for this error. visit the link below.

FIX: PowerPivot workbook cannot do data refresh in SharePoint 2013 after you apply SQL Server 2012 CU7 or in SQL Server 2014

Steps to fix the error:

• Open the workbook in Microsoft Excel 2013.
• On the File menu and click Info.

• Click Properties, and then click Advanced Properties.
• In the Advanced Properties dialog box, click the Custom tab. Then, click each property in the Properties list that has a name that resembles pppDRSplitSchedulePrefix and is followed by a number.

• click Delete to remove all properties that matches above mentioned criteria before you go to the next property.
• Click OK.
• Save the file to SharePoint or Save it locally and upload to Power Pivot gallery in SharePoint.