Connecting PM files to Excel

Topic

New Reply

I’m working on a program and plan to create a MSProejct 2000 master file with smaller project files linked to the master. I also have to maintain a spreadsheet of forecasted capital requests. Is there a way to set up my projects in Project2000 and have milestone tasks linked to a spreadsheet for capital requests? This way each change in schedule would automatically prompt questions about the schedule for requesting capital.

Thanks in advance,

Asmar

Reply | Quote

Replies

One very easy, yet overlooked feature is the ability to copy a value from Excel and paste-Link it into the desired field in Project. Perhaps this could get you started…

Rich P.

Reply | Quote

RichP

Thanks. I’ll experiment and let you know how it works.

T/U

Reply | Quote