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
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
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....