Welcome to the { mindfrost82.com } forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact us.

Go Back   { mindfrost82.com } > Gadget Corner > Tech Newsgroups > Microsoft > MS Office > Project

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 03-25-2008, 02:37 PM
=?Utf-8?B?b3B1czg4?=
 
Posts: n/a
tasks shift after filter or upon reopening file

I'm just beginning to learn Project without the benefit of a class or mentor,
so please bear with me. I'm not even convinced Project is a good option for
what we do, but I wasn't given much choice, so I'm doing the best I can.

When I open Project, it re-sorts my tasks. There are, say, 4 tasks under a
parent task, and they are in chronological order. But when I mark one or more
tasks as completed, the next time I open Project it places them at the bottom
of those 4 tasks. How can I tell Project to stop moving these to the bottom
of the list? It's important that they remain in the same order I placed them,
regardless of completion percent.

Also, numerous times each day I will add one or more new rows of tasks at
varying levels, placed according to related jobs. When I reopen - or after
running a filter or sort - tasks end up nested within other tasks, so they
often are no longer associated with their parent tasks. And many times, it
will not let me indent or outdent to the proper level - when I try to shift
the rows, it puts them somewhere else completely unrelated and I cannot find
them, or it will force them into the middle of another group of tasks,
disassociating the now-interrupted tasks yet keeping the new tasks together
with their parent. I must hit Undo (I can't believe Project only allows one
level of Undo!) and just live with tasks being at the wrong level. This is
driving me absolutely CRAZY!

Since our final deadlines (most of the time) cannot shift, it requires
manual rescheduling when an internal deadline is missed; therefore, the
predecessor/date functionality had to be turned off. Maybe that has something
to do with this?

Can anybody please help with this?
Reply With Quote
  #2 (permalink)  
Old 03-25-2008, 05:13 PM
Jan De Messemaeker
 
Posts: n/a
Re: tasks shift after filter or upon reopening file

See answers embedde

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf
"opus88" <opus88@discussions.microsoft.com> wrote in message
news:22160ED0-D659-4EE6-A147-B4872B3029B2@microsoft.com...
> I'm just beginning to learn Project without the benefit of a class or
> mentor,
> so please bear with me. I'm not even convinced Project is a good option
> for
> what we do, but I wasn't given much choice, so I'm doing the best I can.
>
> When I open Project, it re-sorts my tasks. There are, say, 4 tasks under a
> parent task, and they are in chronological order. But when I mark one or
> more
> tasks as completed, the next time I open Project it places them at the
> bottom
> of those 4 tasks. How can I tell Project to stop moving these to the
> bottom
> of the list? It's important that they remain in the same order I placed
> them,
> regardless of completion percent.



Project Menu, Sort, Sort by ID.
Now save the project

>
> Also, numerous times each day I will add one or more new rows of tasks at
> varying levels, placed according to related jobs. When I reopen - or after
> running a filter or sort - tasks end up nested within other tasks, so they
> often are no longer associated with their parent tasks. And many times, it
> will not let me indent or outdent to the proper level - when I try to
> shift
> the rows, it puts them somewhere else completely unrelated and I cannot
> find
> them, or it will force them into the middle of another group of tasks,
> disassociating the now-interrupted tasks yet keeping the new tasks
> together
> with their parent. I must hit Undo (I can't believe Project only allows
> one
> level of Undo!) and just live with tasks being at the wrong level. This is
> driving me absolutely CRAZY!


Same diagnostic. Your view is sorted. Sort by ID.
BTW, Project 2007 has multiple levels of undo.
>
> Since our final deadlines (most of the time) cannot shift, it requires
> manual rescheduling when an internal deadline is missed; therefore, the
> predecessor/date functionality had to be turned off. Maybe that has
> something
> to do with this?


Most likely not. Still, sin and shame you are not using Project for its
features by turning off calculation.
>
> Can anybody please help with this?



Reply With Quote
  #3 (permalink)  
Old 03-25-2008, 08:55 PM
=?Utf-8?B?RGVhbiBD?=
 
Posts: n/a
Re: tasks shift after filter or upon reopening file

You may have more wrong than Jan identified.

Try the macro below.
Sub ResetView()
'Use this macro when you can't figure out why you can't see something.
'This macro turns off autofilter, filters for all tasks, sorts by ID,
expands the outline to show all tasks then goes to the first task name
ViewApply Name:="Gantt Chart"
GroupApply ("No Group")
FilterApply Name:="All Tasks"
SelectSheet
Application.Sort Key1:="ID", Ascending1:=True, Renumber:=False
SummaryTasksShow (True)
OutlineShowAllTasks
SelectTaskField Row:=0, Column:="Name"
End Sub

"Jan De Messemaeker" wrote:

> See answers embedde
>
> --
> Jan De Messemaeker
> Microsoft Project Most Valuable Professional
> +32 495 300 620
> For availability check:
> http://users.online.be/prom-ade/Calendar.pdf
> "opus88" <opus88@discussions.microsoft.com> wrote in message
> news:22160ED0-D659-4EE6-A147-B4872B3029B2@microsoft.com...
> > I'm just beginning to learn Project without the benefit of a class or
> > mentor,
> > so please bear with me. I'm not even convinced Project is a good option
> > for
> > what we do, but I wasn't given much choice, so I'm doing the best I can.
> >
> > When I open Project, it re-sorts my tasks. There are, say, 4 tasks under a
> > parent task, and they are in chronological order. But when I mark one or
> > more
> > tasks as completed, the next time I open Project it places them at the
> > bottom
> > of those 4 tasks. How can I tell Project to stop moving these to the
> > bottom
> > of the list? It's important that they remain in the same order I placed
> > them,
> > regardless of completion percent.

>
>
> Project Menu, Sort, Sort by ID.
> Now save the project
>
> >
> > Also, numerous times each day I will add one or more new rows of tasks at
> > varying levels, placed according to related jobs. When I reopen - or after
> > running a filter or sort - tasks end up nested within other tasks, so they
> > often are no longer associated with their parent tasks. And many times, it
> > will not let me indent or outdent to the proper level - when I try to
> > shift
> > the rows, it puts them somewhere else completely unrelated and I cannot
> > find
> > them, or it will force them into the middle of another group of tasks,
> > disassociating the now-interrupted tasks yet keeping the new tasks
> > together
> > with their parent. I must hit Undo (I can't believe Project only allows
> > one
> > level of Undo!) and just live with tasks being at the wrong level. This is
> > driving me absolutely CRAZY!

>
> Same diagnostic. Your view is sorted. Sort by ID.
> BTW, Project 2007 has multiple levels of undo.
> >
> > Since our final deadlines (most of the time) cannot shift, it requires
> > manual rescheduling when an internal deadline is missed; therefore, the
> > predecessor/date functionality had to be turned off. Maybe that has
> > something
> > to do with this?

>
> Most likely not. Still, sin and shame you are not using Project for its
> features by turning off calculation.
> >
> > Can anybody please help with this?

>
>
>

Reply With Quote
  #4 (permalink)  
Old 03-26-2008, 04:13 PM
=?Utf-8?B?b3B1czg4?=
 
Posts: n/a
Re: tasks shift after filter or upon reopening file

Hi, Dean!

Thank you for your reply - I appreciate you taking the time and effort to
assist. I had been checking to be sure all tasks were showing, although I
certainly realize I could be missing something. I think your suggestion would
be really helpful if I knew how to do it. Once I found the Macro menu, I
didn't understand how to plug in your information. Sorry - I really am a
beginner with this. But Jan's suggestion did work. Again, many thanks.

"Dean C" wrote:

> You may have more wrong than Jan identified.
>
> Try the macro below.
> Sub ResetView()
> 'Use this macro when you can't figure out why you can't see something.
> 'This macro turns off autofilter, filters for all tasks, sorts by ID,
> expands the outline to show all tasks then goes to the first task name
> ViewApply Name:="Gantt Chart"
> GroupApply ("No Group")
> FilterApply Name:="All Tasks"
> SelectSheet
> Application.Sort Key1:="ID", Ascending1:=True, Renumber:=False
> SummaryTasksShow (True)
> OutlineShowAllTasks
> SelectTaskField Row:=0, Column:="Name"
> End Sub
>

Reply With Quote
  #5 (permalink)  
Old 03-26-2008, 05:26 PM
=?Utf-8?B?b3B1czg4?=
 
Posts: n/a
Re: tasks shift after filter or upon reopening file

Hi, Jan!

Thank you so much! It worked beautifully! Three months of frustration are
erased with a couple of mouse clicks - how simple!

"Sin and shame" accepted - LOL! Yes, we're just using it as an expanded
spreadsheet because it does offer more than Excel. Project is not ideal for
our situation - in fact, it's hugely cumbersome and most functions are not
needed for what we do - but so far nobody makes what would be right for us.
So we're stuck for now.

Again, thank you!
Reply With Quote
Reply

  { mindfrost82.com } > Gadget Corner > Tech Newsgroups > Microsoft > MS Office > Project


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT. The time now is 04:30 PM.


Powered by vBulletin, Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.1.0 ©2007, Crawlability, Inc.
© 1999-2008 mindfrost82.com v11.0


Sponsors:
Credit Check | Indoor Flags | Magazine Subscriptions | Online Loans | Mortgage



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114