Hi all,
I am relatively new to MS Project and was hoping someone could help me. I am building a Gant Chart for my department for things we need to do before and after we receive various samples from another department. So there are about 5 different fixed dates in the project when we receive these samples but they are rough dates until we get closer to them. The other department will then tell us the exact dates. I am trying to link an Excel sheet to my project Gant chart so the other department can just edit the sell with the date and it will automatically update the chart. I have linked the dates by Paste Special, text data, and then set all the tasks before hand to start as late as possible and all the tasks after to start a early as possible. For some reason all the links took on the same date (the latest one). I then set the linked cells to Manual Schedule and they all now have the right dates as that of the spreadsheet cells they are linked to. However, the tasks before hand have, for some reason, a later date than the Manually scheduled tasks causing a conflict. Why if the successor has a fixed date would the predecessor be able to go past it? Even if I set the constraint to start as late as possible? I don't know if the issue is how I am linking the cells or the constraints I am setting. Any help would be very much appreciated. Thank you.
P.S. version 2010.
I am relatively new to MS Project and was hoping someone could help me. I am building a Gant Chart for my department for things we need to do before and after we receive various samples from another department. So there are about 5 different fixed dates in the project when we receive these samples but they are rough dates until we get closer to them. The other department will then tell us the exact dates. I am trying to link an Excel sheet to my project Gant chart so the other department can just edit the sell with the date and it will automatically update the chart. I have linked the dates by Paste Special, text data, and then set all the tasks before hand to start as late as possible and all the tasks after to start a early as possible. For some reason all the links took on the same date (the latest one). I then set the linked cells to Manual Schedule and they all now have the right dates as that of the spreadsheet cells they are linked to. However, the tasks before hand have, for some reason, a later date than the Manually scheduled tasks causing a conflict. Why if the successor has a fixed date would the predecessor be able to go past it? Even if I set the constraint to start as late as possible? I don't know if the issue is how I am linking the cells or the constraints I am setting. Any help would be very much appreciated. Thank you.
P.S. version 2010.