Skip to content
ProjectControls.com
Asta Powerproject

Linking PP dates in an excel doc

In the Open Standard
Christine PMember for 17 years 5 months
Created
3
6
0

Hi all

Im creating a Master Iinformation Release Schedule in excel.  The dates are subject to change so rather than having to change them every time in the excel document, is there any way of linking the dates in the excel document to the dates in the Powerproject file, so that each time the PP dates are changed the MIRS is updated automatically please?

Save Follow Follow forum Report
Reply New topic

3 replies

Oldest first
  1. 0
    Mike Testro ·
    #1

    Hi Christine I do not know of

    Hi Christine

    I do not know of any link available between cells in the Powerproject spreadsheet and Excell.

    You can however copy / paste from any Power Project column into Excell columns.

    The problem is that the time values come with it so you have convert it to date numbers.

    If you want your date in say Column C then paste the dates into column E

    In Column D type =left(d#,10) and that will lift out the pure date data

    In column C type =value(d#) and then format it to the date type you want.

    Whenever you copy paste date columns back into excell Col E the dates will format correctly.

    Make absolutely sure that your powerproject data lines up exactly with you spreadseet columns or your dates will be all over the place.

    Best regards

    Mike Testro

    Report
  2. 0
    Christine P ·
    #2

    Hi Mikeah well - copy & paste

    Hi Mike

    ah well - copy & paste it is

    thanks for the reply :)

    Report
  3. 0
    Andrew Willard ·
    #3

    Hi Christine,   I would

    Hi Christine,

     

    I would normally do this by using tabular reports. A report is created in the same format as the report you want. One click is then all that is need to update the report each time. If you want more information or help on this please let me know.

     

    Regards

     

    Andrew

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?