Workload by week/ month export to Excel
I like to use Visual report, but that doesn’t work.. I have MSProject 2016 and office 365. so I have tried to use save as (export) as xls. But I can’t get the load or week or month. anyone that can help out setup in table format. I think… the I can build the rest in Excel if needed br rune
Project Remaining Duration as of Status Date
In a Project schedule, The % Complete entered during an update doesn't seem to push the task Finish Date as it should. The task has a Start date of 6/9/25, Finish date of 9/23/25, duration of 14.95 weeks. The Status date is 9/12/25, Actual start 6/9/25 (on schedule) but progress is 2% Complete, Remaining Duration is 13.45 wks. When I click Update Project and reschedule uncomplete work to start as of Status Date (9/12/25) the Finish Date remains 9/23/25. Shouldn't the Finish Date push to approx. 12/12/2025 based on the % complete and remaining duration? There are a handful of tasks in this schedule with a similar issue, so I would like to find out what causes this, so we can make the task Finish Dates update as you would expect when updating % complete and Remaining Duration on tasks as of the status date. If someone could point me in the right direction it would be much appreciated. There are no date constraints on the task, and "Split In-Progress tasks" is selected in the Schedule Options. We are using a 4 day a week/10 hours a day calendar. We assign Generic Resources to tasks but this particular task is NOT resource loaded. This task is linked with both a predecessor and successor, and both the predecessor and successor are statused 100% complete. Could this be why Project isn't updating the Finish Date for this task, since its successor is complete? We are using Project Server. This project has been published with the status date of 9/12/25.
LOE Tasks in Project Server
What is the proper way to reflect LOE (Level Of Effort) tasks in MS Project? For example, adding a task showing the PM working 10% of his time on the project, for the duration of the project. If we simply give that task a duration equal to the project, then Project cannot determine the correct Critical Path of the project. In addition, if the project duration changes, the PM will have to manually change the duration of the PM task. If we try linking this task with SS and FF relationships, the duration remains 1 day unless we input the duration, in which case we still have to update the duration as the project progresses. I have tried creating a hammock LOE task by copying and pasting links to the first and last tasks, as described in TenSix Consulting articles https://tensix.com/creating-loe-tasks-in-microsoft-project/ and https://tensix.com/more-about-level-of-effort-tasks-in-microsoft-project/ . However, this does not work in my version of Project Professional. I am only able to link either the starting date or finish date, but not both. Does anyone here have experience with scheduling this type of LOE task in MS Project? We are using on premises Project Server. We want to schedule this type of PM oversight task to plan for the estimated hours of PM time over the span of the project, have the task duration update dynamically if the project duration changes, and be able to status this PM task during the project to reflect the "actual" and "remaining" hours for the task as the project progresses.Schedule Opens in Read-Only Mode from Conference Room Computer
In Project Server, a Project Manager opens his schedule on a conference room computer, but it opens Read Only mode and the PM is not able to check it out and edit/publish the project. We made sure it was not already checked out, and the PM is able to open, edit and publish this schedule from his work station. As far as we can tell, this problem only occurs when opening this one schedule from the conference room computer. We have cleared the cache as described in this handy article: https://www.dalehowardmvp.com/force-check-in-stuck-projects/ but this didn’t solve the issue. I have seen another article https://www.dalehowardmvp.com/how-to-fix-corrupted-files/ about using Save for Sharing to correct possibly corrupted schedules. My question is: would doing this cause any issues since we are accessing the schedule from a conference room? We do not want to adversely affect the way the PM opens this project from their work station. Does anyone have an experience with schedules opening from the PM’s work station but opening Read-Only when accessing PWA from a conference room computer? Would Save for Sharing help in this instance? Thank youTeam Assignment Visibility in Project Server
In on-premesis Project Server, I want "Engineering" Team Members with "My Task" Global permissions to be able to see all tasks that have been assigned to a generic resource that is also part of the Engineering Team Resource Assignment Pool. Then, they can self-assign or simply update the status of these tasks. The PM initially resource-loads the schedule with the generic resource, then when the project starts, we want the various teams to be able to see tasks and provide status updates, without the PM needing to manually assign resources to individual tasks in the schedules (other than the generic resource loaded when the schedule is built). What permissions in Project Server do we need to enable in order for these team members to see all tasks assigned to their teams? Using the BUild TEam page, we have added the Engineering Team Resource Assignment Pool and the individual team members to the project team, but they cannot see the project schedule or any tasks in Project Server.What is a best practice for linking Just-In-Time Tasks?
In MS Project, what is a best practice for linking Just-In-Time tasks, so that a task is scheduled to take place just prior to another task, without use of date constraints or overriding scheduling logic? As an example, I have a task "task prep" that I want to complete just before "important task" starts. "Important task" has other Finish-Start predecessors that determine when it starts. The only thing driving "task prep" is that it must finish just before "important task" starts. These tasks have slack in the schedule that I want to maintain, so I can't use As Late As Possible constraint without pushing both tasks to the right and using up slack. There isn't a task preventing "task prep" from starting, so if I link "task prep" as a predecessor to "important task" with Finish-Start (FS), with As Soon As Possible, then "task prep" will be scheduled to happen long before I want to perform that task. If I use Start-Finish (SF), then the start date of "Important task" drives the finish date of "Task Prep" The dates line up, but SF dependency type is generally not recommended. Also, I do not want to use date constraints, as these are generally not recommended. How can I link these tasks so that "task prep" finishes just before "important task" while adhering to accepted scheduling standards?Project Server Enterprise Global Freeze
We are using on-premises Project Server. The Enterprise Global Template has frozen such that once I open it, MS Project freezes and I can't get to the Organizer to remove custom views (Assuming a custom view has polluted the EGT, as the only thing we do in the EGT is create or modify custom views/tables/filters). How can I access the Organizer to "un-pollute" the Enterprise Global Template? Also, I saved our custom views in an mpp file. How can I tell which view is causing the problem with the Global Template, so I can prevent this from happening in the future? Any help would be greatly appreciated!View all upcoming tasks for all projects in Project Server
How do you create a view in Project Server that shows all upcoming tasks (for example, from today to the end of next month) and their start/finish dates for all projects that are in Project Server? This way a Server user can see all upcoming tasks for the Enterprise, without having to go into each individual schedule? If it's not possible to create such a view, what are best practices for extracting this data into an excel Pivot Table?