I am trying to link start and end dates stored in a MS Project 2007 .mpp file to cells in a 2007 Excel .xlsx file. I want to be able to update the dates in Project and have then automatically update in Excel. Additionally, I want to be able to enter "% Complete"
in Excel and have this information automatically update in Project.
Locally, this can be acheived by copying a cell range and right clicking "Paste Special --> Paste Link." It also works when I first upload it to SharePoint. I upload both documents, open them, and create the links. I am able to change information in one
file (either Excel or Project) and see the updates in the other file (Excel or Project).
Once I close and save the documents, this functionality breaks. When I first open Excel, I am prompted to "Enable" the linking again. Once I do this, all of the information being pulled from Project turns into "#REF." When I check the links, they are exactly
as they should be. They look like this: =MSProject.Project.9|'[company info - redacted]/Shared_Documents/2012_document.mpp'!'!LINK_18'
Additionally, the link in Project is broken and prompt me to repair and eventually times out.
Note: I do not know the version of SharePoint we are on, but I suspect it is 2007. I will find out forsure when our admin gets out of a meeting.
Much apprecated,
Joe
