Re: Compare Utility with External Tasks

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

In article <9E9BB4C5-20DC-4A3A-A060-D5C4C07ADB87@xxxxxxxxxxxxx>,
"ET902" <ET902@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

> Beast is the word for it. I did not create the schedule, I just perform
> schedule analysis on it. The master schedule is made up of 41 seperate
> schedules...yep, 41 schedules for 7000 tasks!! This one subproject is the
> only one I am having a problem with. It almost has to be some sort of
> corruption.
> I would send you the schedule to look at ( just out of a sense of defeat)
> but it is loaded with proprietary info so I can't.
> Do you know of anyway that I can make the linked tasks not be linked
> tasks. In other words, like in excel when you do a paste special values, so
> that the information and links would "look like" they are not external.
> Thanks for your help on this by the way.


ET,
I assume the one subproject you are having problems with is the 160 task
file with 36 external links that you mentioned in your original post.
The quantity of subprojects and total size of the master shouldn't be
any problem. I personally worked with 70+ subprojects in a master of
approx. 10K tasks. The only issue with maintaining that complex
structure is that it requires expertise, experience, and a lot of
patience and discipline.

You mention you suspect corruption. Is one or more of the subprojects
that do NOT seem to cause a problem about the same number of tasks as
the file you suspect has a problem? If so, take a look at the file size
of the subproject(s) without an issue and the file with an issue. If the
file with an issue is significantly larger, (e.g. other files are 100K
while the suspect file is 5 Meg), then yes, the file is corrupt. For
tips and tricks for dealing with corrupt files go to the MVP website at:
http://www.mvps.org/project/faqs.htm
and look at FAQ 43 - File Bloat? Might be corruption

With regard to your files having proprietary information, as I mentioned
previously I have a macro that will de-sensitize the file. If
interested, contact me direct. A similar macro is also available on
fellow MVP, Jack Dahlgren's website at:
http://masamiki.com/project/macros.htm
Look for the "scrub" macro. Either my macro or Jack's macro will remove
all sensitive information yet will not affect file structure.

And finally, yes, there is a method for converting externally linked
tasks to internally linked tasks. I have a macro that will do that but
it is NOT freeware. If you want more information, contact me direct.

Hope this helps.
John
Project MVP
.

Relevant Pages

  • Re: Master Project - Multiple Projects
    ... This is a timely post for me as I am at this very moment setting up a master ... I like the idea of saving a copy of the master schedule once a ... Do I understand the macro you suggest is to place an individual project into ...
    (microsoft.public.project)
  • Re: Managing dependcies when using Multiple Projects
    ... >> 2) Have a master schedule with individual schedules inserted. ... >> locating it's task number and then inserting the projname\taskid in the ... > master contains a pointer to each individual subproject and what you see ...
    (microsoft.public.project)
  • Re: How do I schedule a task to print a document
    ... to save the workbook or not after resetting the signature. ... it keeps on requiring interactive response about enabling macros ... could simply schedule a print-only task as from Explorer. ... Refinements to the print code can be made if you record a macro while making ...
    (microsoft.public.excel.misc)
  • Re: PROJ 2000: Inserted Projects not found
    ... The schedule is inserted linked to the ... If it is and you edit the path in the master but don't also change ... > suggestion of using a message box to clear out the sendkeys buffer, ... > Halted, and if it's been halted, then execute the SendKeys ...
    (microsoft.public.project.vba)
  • RE: Limit Gantt Time Line display
    ... I would do it like this: Open all 5 plans. ... it will update the master. ... files stay in the same folder and never move the files outside of the folder. ... Best advice I can give you is "The folder is your schedule, ...
    (microsoft.public.project)