• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

link MS project start and finish dates to excel

G

greg.begin

Member
I have a MS project file that I want to link to in excel. So if I update the dates on MS project they will update in excel. I have gone through the select the dates, paste special link, and text. I have also done the same on paste special link for excel format but after i close the files and re-open I get a reference issue. The only thing i can think of is that it doesn't work because the schedule is in a sharepoint portal. any suggestions?
 
Greg


I can't comment on use of a Sharepoint portal, But I'd be surprised if that is an issue.


You should be able to select the Tasks in Project

Copy

Goto Excel, paste


Edit


Then select all the Data, Copy

Go back to Project and paste


I haven't used Project for several years but it used to work.

I Can't remember if you had to select the Tasks or Columns in project, So try both
 
You must log in or register to reply here.
Back
Top