Link Project to Excel and Vice Versa

Discussion in 'Project General' started by Scheduling Analyst, Aug 16, 2006.

  1. I would like to set up a system that all of my excel files are based off of a
    project files cells, for an automatic update purpose, to save time. Is there
    a way, either directly or indirectly, to link project cells to excel cells.
    MS Excel has a similar feature where you can ( = ) one cell to the next for
    update purpose. Microsoft should make some kind of compatibility between the
    two to make it more user friendly for the everyday user.
     
    Scheduling Analyst, Aug 16, 2006
    #1
    1. Advertisements

  2. Scheduling Analyst

    Mike Glen Guest

    Hi ,

    Welcome to this Microsoft Project newsgroup :)

    They do:) You can select a cell in Project, copy it and in Excel use Paste
    Special - see FAQ Item: 10 Exporting to Excel. Be warned, however, the
    links are not robust and any changes in thinsgs, like where the files are
    stored, can break links and cause problems.

    FAQs, companion products and other useful Project information can be seen at
    this web address:http://project.mvps.org/faqs.htm

    Hope this helps - please let us know how you get on :)

    Mike Glen
    Project MVP


    FAQs, companion products and other useful Project information can be seen at
    this web address: http://project.mvps.org/faqs.htm

    Hope this helps - please let us know how you get on :)

    Mike Glen
    MS Project MVP
    See http://tinyurl.com/2xbhc for Project Tutorials

    Scheduling Analyst wrote:
    > I would like to set up a system that all of my excel files are based
    > off of a project files cells, for an automatic update purpose, to
    > save time. Is there a way, either directly or indirectly, to link
    > project cells to excel cells. MS Excel has a similar feature where
    > you can ( = ) one cell to the next for update purpose. Microsoft
    > should make some kind of compatibility between the two to make it
    > more user friendly for the everyday user.
     
    Mike Glen, Aug 16, 2006
    #2
    1. Advertisements

  3. This function exists already. Select the information you want to link. From
    edit menu select copy. Switch to excel, select the cell you want to paste to.
    From edit menu select "paste special" and in the dialog box check the "paste
    link" box.

    This method has some issues. Be careful to maintain file names and locations.

    -Jack Dahlgren
    http://zo-d.com/blog

    "Scheduling Analyst" wrote:

    > I would like to set up a system that all of my excel files are based off of a
    > project files cells, for an automatic update purpose, to save time. Is there
    > a way, either directly or indirectly, to link project cells to excel cells.
    > MS Excel has a similar feature where you can ( = ) one cell to the next for
    > update purpose. Microsoft should make some kind of compatibility between the
    > two to make it more user friendly for the everyday user.
     
    Jack Dahlgren, Aug 16, 2006
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. MAR1114
    Replies:
    1
    Views:
    241
    JackD
    Nov 15, 2004
  2. c. bailey

    Project's Cons vs. pros (vice-versa)????

    c. bailey, Dec 16, 2004, in forum: Project General
    Replies:
    1
    Views:
    136
    JulieD
    Dec 16, 2004
  3. Amol Bargaje
    Replies:
    1
    Views:
    136
    Mike Glen
    Aug 14, 2007
  4. Britt
    Replies:
    1
    Views:
    142
  5. Andrew
    Replies:
    5
    Views:
    241
  6. Vit
    Replies:
    3
    Views:
    125
    Mike Glen
    Aug 20, 2008
  7. Tim Mccoy

    Project Pro 2003 - Sub-project Link not Working

    Tim Mccoy, Oct 30, 2008, in forum: Project General
    Replies:
    1
    Views:
    94
    Jim Aksel
    Oct 30, 2008
  8. Karrybelle
    Replies:
    4
    Views:
    151
    Dale Howard [MVP]
    Jan 13, 2010
Loading...