Linking MS Project to MS Excel

L
Lee Mallek 👤 Member for 21 years 1 month
T
Trevor Rabey 👤 Member for 20 years 6 months

OK, this just means that you can’t paste a link just anywhere you like, just as you can’t 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.

L
Lee Mallek 👤 Member for 21 years 1 month

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

A
Alexandre Faulx-Briole 👤 Member for 23 years 4 months

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

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