Hi, I am trying link a value into Excel 2010 from MS Project 2010.
I do so by copying the cell in MS Project and going to Excel 2010 to a paste special as link on Unicode Text.
It works well as long as the Project doc is open.
The excel cell link looks like
=MSProject.Project.9|'C:UsersADesktopProject Plan.mpp'!'!LINK_2'
However, after I closed the project plan doc, the link stops working and I see a #REF! error on the linked cell in excel sheet.
I can not solve it. Can you please help!
Thank you!
ank000
I do so by copying the cell in MS Project and going to Excel 2010 to a paste special as link on Unicode Text.
It works well as long as the Project doc is open.
The excel cell link looks like
=MSProject.Project.9|'C:UsersADesktopProject Plan.mpp'!'!LINK_2'
However, after I closed the project plan doc, the link stops working and I see a #REF! error on the linked cell in excel sheet.
I can not solve it. Can you please help!
Thank you!
ank000