dynamic links between Excel and Project

[vikas]

I tried linking excel information from Excel to Project (via paste special >
paste link > text data).
For some reason changes to the data in Excel is not reflected on Project.
The small corner triangle indicating that it is a dynamic link is seen. If I
try to delete the data, I get the warning box saying its a dynamic link.

Reverse link from Project to Excel works perfectly.

All help appreciated. Thanks in advance.

Vikas

 

[Mike Glen]

Hi Vikas,

Welcome to this Microsoft Project newsgroup

Have you got Automatic Calculation turned on (Tools/Options/Calculation
tab)?

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

 

[John]

I tried linking excel information from Excel to Project (via paste special >
paste link > text data).
For some reason changes to the data in Excel is not reflected on Project.
The small corner triangle indicating that it is a dynamic link is seen. If I
try to delete the data, I get the warning box saying its a dynamic link.

Reverse link from Project to Excel works perfectly.

All help appreciated. Thanks in advance.

Vikas

Vikas,
In addition to what Mike suggested let me add the following. Paste links
are very fragile. If they are not created and maintained with great
discipline, paste links can easily become corrupt. So, be forewarned.

If Mike's suggestion solves your problem and you are already aware of
the fragility of paste links, great. If not, you might want to try a
different approach. If so, tell us what you are trying to accomplish by
linking Project and Excel and we can likely help find a better solution.

John
Project MVp