Skip to content
ProjectControls.com
Microsoft Project

Linking MS Project to MS Excel

In the Open Standard
Lee MallekMember for 21 years 5 months
Created
3
4
0
Does anyone know if it is possible to link MS Project activities to Excel spreadsheets so if a date changes in the Excel spreadsheet it will reflect on the programme? If so how?
Save Follow Follow forum Report
Reply New topic

3 replies

Oldest first
  1. 0
    Alexandre Faulx-Briole ·
    #1
    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
    Report
  2. 0
    Lee Mallek ·
    #2
    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
    Report
  3. 0
    Trevor Rabey ·
    #3
    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.
    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?