Linking MS Project to MS Excel

L
Lee Mallek 👤 Member for 21 years 2 months
T
Trevor Rabey 👤 Member for 20 years 7 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 2 months

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 5 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

Soheil Barekat
4 posts
Luis Jr Ngade
6 posts
Ben Welsher
1 posts
Rohan Dashputre
0 posts
AMECHI ANAKWENZE
2 posts
Jayaprakash Sekar
1 posts
arash.karmand
0 posts
James Williams
74 posts
Vahidazimi01
0 posts
David Smith
4 posts