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. Advertising

  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. Advertising

  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. Advertising

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. Andrew
    Replies:
    5
    Views:
    61
  2. MSCurious

    Can I import Access into Project and vice versa?

    MSCurious, Sep 14, 2005, in forum: Access External Data
    Replies:
    1
    Views:
    71
    John Nurick
    Sep 15, 2005
  3. Vit
    Replies:
    2
    Views:
    131
    Stephen Sanderlin
    Aug 21, 2008
  4. I-Ali
    Replies:
    2
    Views:
    66
    I-Ali
    Sep 20, 2005
  5. Lori
    Replies:
    0
    Views:
    63
Loading...

Share This Page