Linking MS Project to excel

markgoudswaard

New Member
Joined
Oct 8, 2010
Messages
7
Hello,

I'm trying to establish active links from an MS project document to an excel spreadsheet. Through copying and pasting specials I'm managing dumb values and Hyperlinks to the document, neither of which are what I'm after?

Does anyone know how to create the links I'm after? the excel document needs to display the values in the project and update as the project document changes.

I know this seems like an easy question but it's not as easy as it seems!
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

Trevor G

Well-known Member
Joined
Jul 17, 2008
Messages
6,707
Office Version
  1. 2016
Platform
  1. Windows
You should stick to one thread you have already asked this question.

When you use Paste Special look to use the link, but select the Text method this will give you the values in the cells

As long as you have only selected the cells in the project in excel it will display on the formula bar something like this

{=MSProject.Project.9|Project1!'!LINK_3'}
 
Last edited:

SydneyGeek

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251
I don't know of a way to link an Excel workbook into Project.
A couple of options that you could consider:
Export from Project to Excel when you save the file -- you can create a VBA routine to do the job. The only decent VBA resource I know of is a book by Rod Gill.

Save the project as an Access database. It will take a while to work out what all the tables are and how they link, but you can then use the External Data feature in Excel to refresh the workbook whenever you want.

Denis
 

Forum statistics

Threads
1,137,349
Messages
5,680,971
Members
419,947
Latest member
cchristian6

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top