More on Multiple PowerPivot Versions

The previous blog post, Supporting Multiple PowerPivot Versions, contained a PowerShell script that has proven to be very helpful for us on the product team. We get a fair number of workbooks from a variety of sources created with many different versions of PowerPivot, usually with a request for help with some problem that happened when trying to use the workbook. One important piece of data that doesn't always come with the request is the version of PowerPivot that last saved the workbook. Sometimes, we even need this information for test workbooks we've created for our testing. Since we get new builds multiple times a week, the complete version number is needed to determine whether an issue we're having with a workbook is already fixed or not. For all those reasons, the script has proven to be a frequently used tool for us.