Guild of PROJECT CONTROLS is OPEN... Not a MEMBER YET?... JOIN HERE

How to export Resource Usage Spreadsheet from P6 to Excel?

7 replies [Last post]
Nithin Shetty
User offline. Last seen 28 weeks 5 days ago. Offline
Joined: 31 Aug 2004
Posts: 34

Hi Friends,

You are all doing gr8 job helping others.

Can anyone kindly tell me how can I export 'resource usage spreadsheet' from P6 to Excel? Please note that these are resources allocated to portfolio of projects not one project.

I have tried this through reports. But I can't save report as it is showing a message that as the data belongs to multiple projects, report can't be saved.

I really need to export resource usage spread sheet from P6 to Excel. Is there any other convenient way to do so?

thanks in advance. 

Kind Regards,

Nith

Replies

Abuder Shambo
User offline. Last seen 31 weeks 4 days ago. Offline
Joined: 11 Jun 2011
Posts: 8
Groups: GPC Qatar

Thanks

Abuder Shambo
User offline. Last seen 31 weeks 4 days ago. Offline
Joined: 11 Jun 2011
Posts: 8
Groups: GPC Qatar

Thanks

Abuder Shambo
User offline. Last seen 31 weeks 4 days ago. Offline
Joined: 11 Jun 2011
Posts: 8
Groups: GPC Qatar

Thanks Nith Shetty,

Abuder

Dost Hyd
User offline. Last seen 1 year 40 weeks ago. Offline
Joined: 22 Jul 2011
Posts: 4
Groups: None

It would be great if you can share that with the rest of the group.

 

Thanks.

Nithin Shetty
User offline. Last seen 28 weeks 5 days ago. Offline
Joined: 31 Aug 2004
Posts: 34

Thanks Sirichai,

It's working. However I have found an alternate way to do this.

Thanks again.

 

 

 

Sirichai Somthong...
User offline. Last seen 24 weeks 4 days ago. Offline
Joined: 17 Nov 2009
Posts: 4

Dear Nith Shetty,

Just you copy from Assigement Resource window in P6. as following steps.

1.You have to be on Assigement Resource window  first.

2. then Press Ctrl+A

3.Press Ctrl+C

4.Paste on Excel

Hope you will be succesfully as the above steps.

Nice to meet you.

Best Regards,

Sirichai S.

Skpye name: josirichai

Nithin Shetty
User offline. Last seen 28 weeks 5 days ago. Offline
Joined: 31 Aug 2004
Posts: 34

Hi All,

In continuation to my above query, the specific message shown when i tried to save the report is "You may not save a project-level report while you have more than one project open".

I am struct here. Please suggestions people.

Thanks.

Kind Regards,

Nith