Link to excel from Project Server

[Keith Duncan]

I am having trouble linking data from my Project file to excel. I select a
series of cells from within MS Project and perform a paste special (link,
text) into excel.
Initially the data displays correctly and the link appears as follows within
excel:

=MSProject.Project.9|'<>\Vespa Release'!'!LINK_11'

When the excel workbook is then re-opened, all of the linked data is no
longer available.

What is the correct syntax to specify the full path to my Ms Project file
stored on our project server. (I am guessing that the <> needs to be replaced
with the full path).

Thanks in advance

 

[Jack Dahlgren MVP]

I do not believe those links will work unless the project is open at the
time.

-Jack Dahlgren

 

[Steve]

When you replace '<>\Vespa Release' with a valid file pathname, everything
updates correctly. So the path to the SharePoint server seems to be the
problem.

First, the obvious. Have you tried 'http://servername/site/library/filename'
?

Unfortunately my dev server is not working at the moment or I could test
this for you.

 

[Jack Dahlgren MVP]

The trouble with this is that projects stored on project server are NOT
files.
They are stored in the database. The link in the Excel file has no way to
connect to the database by simply using a path.

-Jack Dahlgren

 

[Steve]

Understood. This is why I suggested using a URL. SharePoint can translate
that to a SQL record, so I'm hoping that Project Server can too. But as I
said, I don't have a platform to try it on at the moment.

 

[Kaldewei]

Hello Keith,
I have the same problem as you.
I tried the hint to use the path from the share point site.
Did not work.
Have you already found a solution?
Best regards,
Gerd

 

[Keith Duncan]

I tried to edit the excel file by replacing the <> with the url as suggested
above. Unfortunately, excel will not allow me to edit the entries as it
responds with the error "You cannot change part of an array".

If anyone has any further suggestion on how to create a simple link of data
from a project file stored on server to an excell file, please let us know.
Thanks
Keith

 

[Steve]

Keith,

You mentioned that, in Excel, you tried Paste Special before. Have you tried
Paste Link? This works slightly differently.

HTH

 

[Jack Dahlgren MVP]

It is not going to work.
To get data from a project on project server you can't use paste link.

In general pasting links is an unreliable way to move data from project to
excel even WITHOUT project server in the way.
I recommend not using it as it breaks easily and is difficult to
troubleshoot and repair.

-Jack Dahlgren