I have problems with excel sheet powerpivot data initialization issue. The error message:

  "Initialization of the data source failed. Check the database server or contact your database administrator. Make sure the external database is available, and then try the operation again. If you see this message again, create a new data source to connect to the database". 

   When the excel sheet is opened with Microsoft Excel manually, there is no issue; but, when the VB script coding with opening the excel sheet, some of excel sheets will have the error message. One of Excel sheets has issue, with OLAP Drill through: 1000000, changed to 1000, the error message goes away. 

   I edit global environment variable: VSTO_SUPPRESSDISPLAYALERTS  to 0, and then, some of excel sheets have error message next is "The embedded powerpivot data is corrupt. You have the following options", I chose "Attempt to recover the structure of the powerpivot data"; but the reports in pdf shows empty data.

  Need help to figure out this initialization issue.