PROBLEM TO COPY RESOURCE ASSIGNMENTS TO EXCEL

Hi all,

     I also encountered the same issue, but when I tried to select the “Hide if empty” check box under the “Group and Sort” tab all the date(month) which is empty will not be included when I paste it to excel sheet. It will only copy the PS and PF date of the project. 

try ctrl-C for copy then ctrl-v to paste as in any winidows based application

I am facing a similar issue. on the assigment view, I have done the grouping by Resource name and then WBS. I have checked "Show Grand Totals" in Display options. After I selecting this view (Ctrl+A) when I try to copy (Ctrl+C),  the Total, Resource name and WBS are getting de-selected and I cannot copy/paste that to excel sheet. I tried this with changing the grouping to Resource ID name, still facing same issue. What is the cause of this issue and what is the solution? 

Select the first month and data press the shift and control key (HOLD THEM BOTH DOWN) now go to the right and select the last month of your data 

Hi all,

I had the same problem occured to me as well. F5 Refresh command did not work for me.

However, changing the levels in Grouing to 'Resource ID Name (Levels ...)' solved the problem of copying and pasting directly from P6. Now I can use my Ctrl+C. Hope it helps.

Regards,

Talgat Baimukanov

Hi all,

I had the same problem occured to me as well. F5 Refresh command did not work for me.

However, changing the levels in Grouing to 'Resource ID Name (Levels ...)' solved the problem of copying and pasting directly from P6. Now I can use my Ctrl+C. Hope it helps.

Regards,

Talgat Baimukanov

not sure why but this solution always works for me

work around is to use the snipping tool and take a screen shot of the area paste it into excel and manually duplicate the screen shot. 

Hi Zoltan,

Thank you for your reply.

I already made that what you had explained but still the same I cannot extract the exact data I wanted to get.I am using now report wizard which will take time.I was still hoping that you can provide more another options.

Hello Robin,

Pressing F5 or refreshin the program still didn't work out.Doing report wizard was my last option as of now that is taking time.Hope you can provide more options.

Thanks

Hi all,

This is a very common issue, and has to do primarily with hardware constraints. If you are copying from the resource assignments table to excel for s-curves etc, sometimes it does not allow you to select the entire range.

Quite simple, hit F5 to refresh data, this should most of the time work, and then you can re-select all the data, alternatively restart your P6.

I do not know what you mean by setting the time scale. All you do is highlight the values you want from when want to start to copy them to when you want to finish copying them. 

Select the first month and data press the shift and control key now go to the right and select the last month of your data 

leave go of the shift key and the control key and press control-v

in excel press control-v

done 

I already set the timeframe to Baseline Project start and finsih manually by costumizing but still the same output I got.

Thanks for your reply.

try going a few months PAST (to the right of) the PF date when highlighting then copy then paste

I face the same problem with this one and it will be much more help if you can give more detailed sequence in timeframe settings with filter activities.

Thanks,

I face the same problem with this one and it will be much more help if you can give more detailed sequence in timeframe settings with filter activities.

Thanks,

I think that probably

1) When you selected the data to be copied, the data range highlighted to be copied (when you selected the data) did not include the time range that you want. - verify if your selection of data to be copied includes the PF date

2) maybe a hardware limitations of your computer RAM - may need to increase

By Selecting all from Edit and then Copy-You can pull in dates...todays and furture

I cannot find to pull past history-progressed history.

Also, it will only copy over a total assigned per day-I can not get it to copy over 2-shifts-even though I have it displayed??

odd...I'm in P7 learning something new every day and scratching my head daily as well lol.

By Selecting all from Edit and then Copy-You can pull in dates...todays and furture

I cannot find to pull past history-progressed history.

Also, it will only copy over a total assigned per day-I can not get it to copy over 2-shifts-even though I have it displayed??

odd...I'm in P7 learning something new every day and scratching my head daily as well lol.

We use a P6 report to do this, not a screen copy.

Hi Maria del Mar Naz 

Last Option is to check one by one and copy in excel or check by installing in another system

Regards

Shahul

Hi Maria del Mar Naz 

I do agree,because it happened to me while using P6.1 try using P6.7 it works well

Regards

Shahul

Hi Maria del Mar Naz 

Click and copy form the top WBS and paste in excel it works based on time scale settings

Cheers

Shahul