How can you link Excel cells to dates in Microsoft Project?

D

Daisy Lynn

I am needing to link dates in a project file to an excel file. I also want
the dates to update automatically when the dates in project are updated.
 
J

John

Daisy Lynn said:
I am needing to link dates in a project file to an excel file. I also want
the dates to update automatically when the dates in project are updated.

Daisy,
Well there are various ways to link the data. One way that will provide
automatic updates is to use the Paste Link feature, but... using paste
links requires careful setup and a lot of maintenance discipline or
corruption will result.

A much more robust approach is to either export the data using an export
map (static data) or a custom VBA macro. Neither of these methods will
provide automatic updates but they can be set up for a simple toolbar
button update.

How lucky do you feel?

John
Project MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top