Forum Discussion
Solved
Linking a value in an Excel cell to a cell in Project
Hello all! We link numerical values from Excel to Project (we use percent complete worksheets in Excel that post to "% Work" rows in Project). This works okay and updates in real time (as soon as th...
You are using Paste Links to link Excel data to Project and I must warn you that paste links are fragile and prone to corruption. If they seem to be working for you I'd say you are very lucky.
With paste links there is no clear method for seeing both "source" and "destination" in the Edit LInks window. You can click on a link in Project and hit "open source" and you will be shown which Excel cell is the source, but it's a "hunt and peck" process. It may be possible to automate a "seek and find" process with VBA but a much better way to accomplish what you are doing is with VBA itself (i.e. no paste links).
However, since you are only importing percent complete, have you tried an import map?
John
Thanks for the quick reply John! I will look into Mapping this information. Have a nice day!
Okay, let me know if you need further help or, if I answered your question, please consider marking my response as the answer.
John
John