Skip to content

Export Activity Usage Spreadsheet to Excel

Ahmad MahrousMember for 10 years
Created
2
1
0

Hi Friends,

I want to export the full activity usage spreadsheet containing planned and earned value by month to excel. I tried Ctrl+A > Ctrl+C in activity usage spreadsheet screen but when I past it in excel I got only timescale and activity columns(activity ID, start, end  ...etc) without any values for planned or earned value. What is wrong I am doing?

Thank You

2 replies

Oldest first
  1. 0
    Domingo Bonaobra ·

    Hi Ahmad,It seems you copy it

    Hi Ahmad,

    It seems you copy it from Activity Layout Window,

    Have you tried copying all activities in Activity Usage Spreadsheet Windows and pasting it in Excel Sheets, It works for me.

    Hope it will helps....

  2. 0
    Zoltan Palffy ·

    you have to go to Project

    you have to go to Project Resource Assignments then roll it up 

    select your starting point (month) and starting value then press and hold the shit and control keys and select the end month and data value 

    then press Ctrl-C for copy 

    got to excel and press Ctrl-V for paste 

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?