Project Online: Updating OData connections in Excel for different PWA instances

Interesting question came in from one of our good partners, Campana and Schott, concerning the update of the connection string for Excel reports based on OData when moving the Excel books between different Project Online tenants.  This works just fine when just using the normal Excel features such as PivotTables – but you run into…


Excel 2013: Error opening saved PivotTable reports from PWA BI Center

A problem that has been around for a little while has ben when re-opening a PivotTable that was created from the OLAP templates within the Business Intelligence (BI) Center within Project Web App (PWA) you will see an error – We found a problem with some content in ‘NameofSpreadsheet.xlsx’. Do you want us to try…