Linking MS Project to MS Excel
Forum Sponsor
Top Posters
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts
OK, this just means that you cant paste a link just anywhere you like, just as you cant type data into just any cell. I suspect that you are trying to paste dates into a Summary Task (heading) or similar. These are always calculated by MSP from the dates of the sub-tasks. Try pasting your link into a task cell.
After following the instructions a box appears stating: The paste link failed. You Cannot paste into a field that Project calculates automatically?
Please advise
Thanks
Lee
Lee,
1. in Excel, select the appropriate cells and click Edit, Copy
2. in MS Project, select the appropriate cells and click Edit, Paste special, with link, text
3. DO NOT move the files, or you will have to refresh the link
Cheers,
Alexandre