Determining Whether An Excel Workbook Contains PowerPivot Data

One of the issues with the 1st version of PowerPivot for Excel is that the add-in does not expose a programmatic interface with Excel. Thus, the data in the PowerPivot window cannot be manipulated through VBA or VSTO. This creates a problem in that there is no straightforward way to identify whether an Excel workbook contains data that has been pulled into the workbook by PowerPivot. Of course, this can be done manually by opening the PowerPivot window, but that method might be tedious if you had several hundred files to check.