Skip to content

PROBLEM TO COPY RESOURCE ASSIGNMENTS TO EXCEL

Maria del Mar NazMember for 15 years 1 month
Created
23
7
0
To COPY the resources from p6 to excell I do as follows: On the assignment screen, I group the screen as I prefer and on the right pane of the screen right I customize what to include,remaining early and late units. Then I chnage the time scale to what I want(from ps TO pf).after that and on the right pane, highlight the items and press ctrl C and then ctrl V in an Excel file. The problem is that even if I change the timescale to finish in the PF DATE when I copy the information TO excel he last date that is copied istn the PF Date and because of that i do not have the complete remaining late units distribution. Thank you in advance

23 replies

Oldest first
  1. 0
    Shah. HB ·

    Hi Maria del Mar Naz Click

    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

  2. 0
    Maria del Mar Naz ·

    Hi shahul When I did it i

    Hi shahul When I did it i copied from the top of the wbs, I Aldo tríed with the select all comand, and even if the time scale is set from the project start to the project finish, some of the columns were not copied
  3. 0
    Shah. HB ·

    Hi Maria del Mar Naz I do

    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

  4. 0
    Maria del Mar Naz ·

    I am using p6.7 any idea of

    I am using p6.7 any idea of what the reason may be?
  5. 0
    Shah. HB ·

    Hi Maria del Mar Naz Last

    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

  6. 0
    Sandy Matheson ·

    We use a P6 report to do

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

  7. 0
    Jeannie Henderson ·

    By Selecting all from Edit

    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.

  8. 0
    Jeannie Henderson ·

    By Selecting all from Edit

    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.

  9. 0
    Anning Sofi ·

    I think that probably1) When

    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

  10. 0
    Tommy James Nuneza ·

    I face the same problem with

    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,

  11. 0
    Tommy James Nuneza ·

    I face the same problem with

    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,

  12. 0
    Zoltan Palffy ·

    try going a few months PAST

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

  13. 0
    Tommy James Nuneza ·

    I already set the timeframe

    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.

  14. 0
    Zoltan Palffy ·

    I do not know what you mean

    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 

  15. 0
    Robin Clare-Talbot ·

    Hi all,This is a very common

    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.

  16. 0
    Tommy James Nuneza ·

    Hi Zoltan, Thank you for your

    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

  17. 0
    Zoltan Palffy ·

    not sure why but this

    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. 

  18. 0
    Talgat Baimukanov ·

    Hi all,I had the same problem

    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

  19. 0
    Talgat Baimukanov ·

    Hi all,I had the same problem

    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

  20. 0
    Zoltan Palffy ·

    Select the first month and

    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 

  21. 0
    Santhosh Kumar ·

    I am facing a similar issue.

    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? 

  22. 0
    Zoltan Palffy ·

    try ctrl-C for copy then

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

     

     

  23. 0
    Bonsio Noval PMP ·

    Hi all,     I also

    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. 

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?