×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

How to create dynamic Link to Excel? - Novice User

How to create dynamic Link to Excel? - Novice User

How to create dynamic Link to Excel? - Novice User

(OP)
Hello,

I have Microsoft Project Table that contains several fields in there. I would like to link this table into a spreadsheet in Excel.

My purpose is to create Dynamic link. If the rows have been added or updated in the Project, the Excel Spreadsheet will also update that information.

I used the Help Menu from Excel but it was too convoluted and was difficult to understand. I do appreciate a step by step guide from a novice user.

What I have done so far was I was able to import the Project Table into my Excel sheet. I am unsure whether that information is static or dynamic. I am concerned that I might lose that information if I accidentally delete the cells on the spreadsheet.

Thank you again.

RE: How to create dynamic Link to Excel? - Novice User

Tamrak
Have you try to “copy” each cell of the project table and “paste special” with link in excel?

RE: How to create dynamic Link to Excel? - Novice User

Tamrak,

RFCZ has the right solution--Copy and "Paste Special" the MS Project items you want to track into corresponding Excel cells. When you see the Paste Special dialog box, check the Preserve Excel Formatting option so you don't have to reformat after pasting, unless you want to format after you've linked the data.

Yes, this is tedious but you only need to do it at the beginning.

If you move either the Project or the Excel documents, you can relink from the Excel document under the Edit > Links function. I've also experienced an occasional cell losing it's link, so you might have to repaste those.

You can Copy and Special Paste ranges of items from Project to Excel, but you can't manipulate the formatting in Excel within the array, such as inserting or moving lines.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login



News


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close