Export Activity Usage Spreadsheet to Excel

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

Z
Zoltan Palffy 👤 Member for 16 years 11 months

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 

D
Domingo Bonaobra 👤 Member for 15 years 9 months

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

Forum Sponsor

Top Posters

Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts