none
removing datalabels from table contents in resource usage view RRS feed

  • Question

  • I want to export the raw data from project resource usage view to excel. I've tried using the reports but not too keen on them yet and want to manipulate the data myself and then produce the graphs in excel as I want to fiddle around with the formatting quite a bit.

    I sucessfully did this for one project file but all data, if copy/pasted, has the time unit with it (in my case "d" or "days"), I want to know how to alter the viewing option in Project to get rid of that data label in each cell so that I can export the data directly. If this is not possible or as an alternative I would like to know how to export the raw data in a slightly more sophisticated way than copy/pasting and then deleting the labels for each value, whilst not as sophisticated as using pivot tables etc as with the reports.  many thanks.

    Tuesday, January 8, 2013 2:29 PM

Answers

  • Hi purplemexx,

    I'm afraid you cannot turn off the labels in Project in a view.  However after copying and pasting into Excel, a quick find/replace all should get rid of the label.  Find d replace with a space character.

    The ultimate method is to export the data out of Project using VBA.  If you have some interest, Rod Gill has published a terrific book on working with Project and VBA.  You can view an excerpt from his book dealing with timephased data here: http://msdn.microsoft.com/en-us/library/ee355231%28v=office.12%29.aspx  The link is for Project 2007.

    You can view details on Rod's book here: http://projectvbabook.com/index.html

    Julie


    Tuesday, January 8, 2013 2:49 PM
    Moderator

All replies

  • Hi purplemexx,

    I'm afraid you cannot turn off the labels in Project in a view.  However after copying and pasting into Excel, a quick find/replace all should get rid of the label.  Find d replace with a space character.

    The ultimate method is to export the data out of Project using VBA.  If you have some interest, Rod Gill has published a terrific book on working with Project and VBA.  You can view an excerpt from his book dealing with timephased data here: http://msdn.microsoft.com/en-us/library/ee355231%28v=office.12%29.aspx  The link is for Project 2007.

    You can view details on Rod's book here: http://projectvbabook.com/index.html

    Julie


    Tuesday, January 8, 2013 2:49 PM
    Moderator
  • Hello Purplemexx,

    Have you tried saving your project directly in Excel's format. Just go to "Save as..." and select Excel Workbook.

    It'll start a wizard to guide you through the export process. You will get raw data in Excel.

    Best regards,


    Rene Alvarez

    Wednesday, January 9, 2013 5:42 PM