Timesheet Single Entry Mode
We have been using timesheet single entry mode to decouple actuals from the MS project file and user timesheet actuals. We plan to evaluate the users actuals from their timesheets in BI to reassess our baselines (specifically focusing on effort) and will ignore the actuals from the mpp file. This has worked as expected except for one scenario. When a PM marks a task complete in the project file and a user has logged any amount of time to the task in their timesheet, no project actuals push to the users timesheet (as expected/desired); however if a user has not yet logged any time against that specific task, the assignment planned work in the project file (now actuals) will push up to the users timesheet. We do not want any project actuals pushing to a users timesheet regardless of whether they have filled in their timesheet yet or not. We need the work actuals completely decoupled [timesheet work inputs do not update the project task status and project work inputs do not update the users timesheets]. Please help.
Export a project as .mpp from Project Online
Hi, I have a project created in Project Online and need to share the .mpp project file with a client. However, although there are options to export as Excel or PDF, I am unable to export to .mpp. Is exporting from Project Online to .mpp even possible? I have been referring to this article - https://docs.microsoft.com/en-us/projectonline/connect-to-project-online-with-the-project-online-desktop-client which looked promising. I am on a Mac but I have a colleague with a Windows laptop and he has Project Professional desktop client. Has anyone tried this approach? But I am unable to figure out the Project Server URL referred to in the article. I have tried the URL of my Project Online project but this doesn't work. Any help here will be really appreciated.Major Functionality Change in Project Online Desktop: Copy-Paste No Longer Transfers Full Task Data
Hi, I'm having a problem with the task copy-paste functionality, which I use very frequently, in the most recent release of Project Online Desktop Client. I'd love any help you can provide. Description of the Problem: Recently, when copying tasks in Microsoft Project Online Desktop Client, only partial task data is being copied and pasted. Previously, when selecting an entire task row (including summary tasks) and copying it, all task-related data would be copied, including: Resource assignments Work Assignment units Duration Start and finish dates Predecessors and successors Task constraints (e.g., "As soon as possible") Notes All sub-task information for summary tasks (with correct indentation) Upon pasting, this data would be transferred in its entirety, allowing for efficient duplication of task structures and bulk modifications using find/replace. Now, when performing the same action, the behavior has changed. After copying, only the task name is pasted. The following issues occur: Incomplete data transfer: Only the task name is pasted, and no other task details (resource assignments, dates, durations, etc.) are carried over. Loss of summary task structure: For summary tasks, the sub-tasks are not properly indented; instead, the sub-task names are pasted as independent tasks, with no hierarchical structure. Task constraint issue: Pasted tasks now seem to have a "Finish no later than..." constraint applied, which appears to be derived from the original finish dates. This suggests the finish dates are being pasted as fixed constraints, overriding the original "As soon as possible" constraint that the task originally had. It seems as though the copy-paste functionality is not pulling all data fields from the task row but instead is only capturing a subset (task name and finish date). This behavior is different from what used to happen, where all task attributes would be included in the copy-paste operation. Is this an intended change or a bug? Has anyone found a workaround to ensure all task details are copied when using copy-paste functionality in the Desktop Client? Can I adjust settings to restore the original copy-paste behavior? Could this be related to a recent update or settings change in Microsoft Project? Are there any known changes to how Microsoft Project handles copying tasks between project files, or perhaps with Project Online Desktop Client specifically? Can this be escalated to the Project development team? Thanks for any help you can provide. Rob MS Project user since 1996
End dates of Subtask are appearing wrong
Hi there, I'm facing issue with import of xml file. When I import the file, Finish date of task having subtask, gets disturb. I am attaching the screenshot from xml file indicating the dates that I have set in it Heres the screenshot from Microsoft Project when I import the xml file After going through multiple solution, I found one of them partially working which suggested that i should turn off project calculation after each edit After applying this setting and re-loading the xml, Finish date of parent task appear corrected but for its subtasks which has duration greater than one, it still appears wrong Can someone please suggest me a solution for this ?Project web app- No up to date data via OData feed
Hi all, we are working with the project web app. The Data stored in the project web app is pulled via the OData feed connector into a PowerBI report. The project web app is hosted on https://company.sharepoint.com/sites/pwa, the data is pulled from https://company.sharepoint.com/sites/pwa/_api/projectdata. The connection and data refresh was working for months without an issue, last week I have added two enterprise custom fields in the PWA and made some changes to the Enterprise Global. When opening the enterprise global a cache limit error appeared in Project Desktop, which was resolved by deleting the cache. I had to do a forced check in of the enterprise global in the PWA settings. I also got an error when loading the "Tasks" table in Power BI, an issue with one of the newly added enterprise custom fields was reported. This issue just appeared once, seems now to be resolved. Since then, I have not gotten any up to data from the PWA via the OData feed into PowerBI. When looking directly in the PWA the data gets updated, but gets not submitted via the OData feed anymore, some "old" versoin of the data gets submitted, I can run the data refresh against the OData feed without any issue but returns only "old" data. I also have 2 "Project Save from Project Professional" jobs under "Manage queue jobs" with job type "Cancelled" which I cannot remove / cancel from the list. How can I solve this? Thanks in advance
MS Project Professional - VBA Color row based on field value
I have a master project with code below. What it does it: whenever I change the field Text12 to "OK" or "NOK" (and other words) it colors the whole row with a specific color (see Module1). It works great at a master project level, that is, in tasks directly in this master project. (How it works: It checks for changes in the Text12 column and sets a bool to true. Then, in Proj_Change, it applies the colors to the correct task row) However, it doesn't work at a Subproject level. I've added Debug.Print to each sub, and when I edit a Subproject's task, it only calls up to App_ProjectBeforeTaskChange. Is there a way to solve this? Detect changes in Subprojects and color the rows? I've tried running the ApplyColor sub directly from the App_ProjectBeforeTaskChange sub, but VBA says "this method is not available in this situation". Also tried using a Timer, didn't work, same error. (PS: I also posted this on Stack Overflow but I couldnt get help, so I'm posting this on other forums) ThisProject: Private Sub Project_Open(ByVal pj As Project) InitializeEventHandler End Sub Module1: Regular Module Option Explicit Dim EventHandler As EventClassModule Sub InitializeEventHandler() Set EventHandler = New EventClassModule Set EventHandler.App = Application Set EventHandler.proj = Application.ActiveProject End Sub Sub ApplyColor() Dim t As Task Set t = EventHandler.ChangedTask If Not t Is Nothing Then SelectRow Row:=t.UniqueID, RowRelative:=False Select Case EventHandler.NewValue Case "OK" Font32Ex CellColor:=14282722 'green Case "NOK" Font32Ex CellColor:=11324407 'red Case "PROGRESS" Font32Ex CellColor:=65535 'blue Case "REPEAT" Font32Ex CellColor:=15652797 'yellow Case Else Font32Ex CellColor:=-16777216 'no color End Select End If End Sub EventClassModule: ClassModule Public WithEvents App As Application Public WithEvents proj As Project Public NewValue As String Public ChangePending As Boolean Public ChangedTask As Task Private Sub App_ProjectBeforeTaskChange(ByVal tsk As Task, ByVal Field As PjField, ByVal NewVal As Variant, Cancel As Boolean) If Field = 188743998 Then 'Custom field Text12 Set ChangedTask = tsk NewValue = NewVal ChangePending = True End If End Sub Private Sub Proj_Change(ByVal pj As Project) If ChangePending Then ApplyColor ChangePending = False End If End Sub
task drop down not working
I have a project running with a number of task sections with indents, one of these has stopped displaying the sub tasks when i click on the triangle icon ( hope this makes sense) . All others are working. Is there an easy fix or would it be better to re-write this section?
MS365 Project Drawings
We have a strange issue with drawings in MS Project. We draw a text box and we save the file. if we open the file again the drawing is gone. If we open the file on a different computer the textbox is showing. I've uninstalled project but the problem stays. Is there anyone here who has a suggestion were to look. Here soms Images with the problem
