How can we Extract Actual Time Data 'By Day' from Project 2016 Desktop?

Stewart 106 Reputation points
2021-02-05T13:20:07.3+00:00

For Project Desktop (2016 Professional), how can I export Actuals and Scheduled Work by resource by day?
We can enter the data in the Resource Utilisation Sheet but we dont seem to be able to get at the data.
I have tried using reports and 'save as to Excel' but the data fields do not appear to be available.

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,687 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,685 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erin Ding-MSFT 4,461 Reputation points
    2021-02-08T10:23:44.89+00:00

    Hi @Stewart

    Do you means that you don't see the fifth step in "Export your project to Excel"?

    Please firstly repair Project to check this issue.

    You could provide related screenshot to better troubleshoot this issue.

    If I have any misunderstandings or if you have any updates, please let me know.

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.