Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MSP 2007 -- HowTo Freeze Task Dates in an MPP file 2

Status
Not open for further replies.

Jackson920

IS-IT--Management
Apr 16, 2012
8
US
Hi:
I've got a resource loaded schedule in MSP 2007. I have been sending my client the schedule as a PDF, because I don't want them to see assigned resources or work. I just want them to see Task ID, Name, Start, Finish, Predecessor and Successor fields. They are insisting on getting the MPP, so they can do what-if scenarios. My question is how can I freeze the dates in the schedule, so that when I remove work and resources, the dates don't change? Does anyone have any recommendation what the best way to do that is?

Thanks,
David
 
You can assign a Must Start On constraint for each task, and then a fixed duration. That will "fix" the start date and duration. It will have to be a special version of the MPP because it won't do resource loading and balancing after you fix the start date and duration.

==================================
advanced cognitive capabilities and other marketing buzzwords explained with sarcastic simplicity


 
Thanks John: I was experimenting with this last night and did exactly that, but I was getting strange errors on some tasks with the must start on, so I switched to start no earlier than. I also added two date fields and copied the start and finish dates into these date fields before I made any changes. Then I could do a compare Date1 does not equal [Start] and fix anything that had changed. It's a good enough solution.

Ideally, it would be nice if I could lock the resource and work columns, so that they weren't viewable and then I could just send them the file without the above manipulations. There is no version of MSP that has that capability, is there?

Thanks again for your answer!

Regards,
David

 
As far as I know, if you give them the MPP, you give them the ability to see and change those fields. Julie is the MVP here, and she may know a way to protect those columns in some way, so hopefully she stops by and takes a look at this thread.

==================================
advanced cognitive capabilities and other marketing buzzwords explained with sarcastic simplicity


 
ok, thanks John. If MSP2010 has a function to lock columns so they couldn't see it, I have access to that version too.
 
John is correct. If you give someone an mpp file, they can change any field, see all data. There is no version of Microsoft Project that allows for the locking of fields. Sorry.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top