Grant reporting access in Project Online

< More Project help

Before you can use Project Online reports in Excel Online, the tenant administrator needs to activate this feature for the Project Online site collection.

  1. Sign in to Office 365 with your admin account.

  2. At the top of the page, select Projects. Or, select the app launcher Office 365 app launcher icon , and then select Projects.

  3. Select Settings Settings icon > Site Settings.

  4. Under Site Collection Administration, select Site collection features.

  5. Scroll down in the list to Project Web App Permission for Excel Web App Refresh, and then select Activate.

    Project Web App Permission for Excel Online Refresh

    Tip:  If you have more than one Project Online site collection, make a note about which one has Project Web App Permission for Excel Online Refresh activated. When you activate it on one site collection, it is activated for all site collections in your Office 365 tenant. However, if you ever want to deactivate it, you can only turn it off from the site collection where you activated it initially.

You should now be able to refresh your Project Online reports in Excel Online.

Important:  Before using the default Project Online reports (Project Overview, Resource Overview, and Project Overview Dashboard), you may need to open each report in Excel 2013, refresh the data, and then save the report back to Project Online. This will update the report so that it is supported by Excel Online.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!