Project Tag

Auto Calculate is switched off by mistake (CTRL-F9) Recently one of my customers was having an issue with Project not "behaving"correctly.  As I was demonstrating how Project works, he was doing the same but without anything updating on his project.  I don't often see this problem...

Managing Sprints and Agile in Project Introduction This is the second in a two part series covering the Agile capabilities of Microsoft Project. In the first article, we discussed Kanban boards. Now we will look at Microsoft’s Scrum implementation, or, to use the Microsoft terminology, Sprint Projects....

<flat white (again)> Using Row Level Security to Auto Filter your Power BI Reports Without a doubt I think Power BI is one of the greatest tools Microsoft has released in the last few years, it truly has revolutionised and democratised data (oh no, I'm beginning to...

<Tuborg> Using Kanban Boards in Microsoft Project Introduction There has been a lot written over the last year regarding Microsoft’s foray into the world of Agile Project Management by way of new improvements into Microsoft Project. This article provides an update based upon one of the latest versions,...

<G&T> Modifying the Menus in Project Over the years I have run hundreds of training courses and one of the issues I often hear from people is the complexity of the ribbon, because there are simply too many icons, and people aren't sure which ones to use...

<Tetley Tea> Project Online Work and Capacity Graphs in Power BI - solution starter A lot of my work now revolves around producing Power BI reports using the Project Online oData feed (you can find my reporting pack for Project Online here) , and of course one...

<flat white> Creating Resource Work and Capacity Graphs in #MSProject A customer posed the challenge earlier this week of producing a work and capacity report using the Reports feature in MS Project.   Using the existing Resource Overview Report I was happy with getting the total work per resource from...

<ice cream> I’ve been meaning to write about Durations for a while, and was inspired to get a move on when I read fellow MVP and cousin Dales Howard’s blog on trusting the schedule. During every training session and Project Online consultancy engagement I always talk about...

<white cappo> One of my customers recently commented that his projects always had a start date of 12th October 2009… After some investigation it became apparent that it was the way he was creating the project file.  Most people will just open Project and a new file...

<coffee> One of my customers recently wanted to calculated %Planned for each task (and therefore each project).  They had done a little research on the net but the formula they found didn’t work in Project Online, only MS Project. So what is %Planned? In it’s simplest form, %Planned...

<Coffee> Introduction Over the months and years I’ve seen a tonne of issues regarding the ability, or inability to edit Enterprise Calendars.  I started a blog about this a while ago http://applepark.co.uk/issues-with-multiple-project-server-accounts/ which provides some troubleshooting issues.  This blog is an update to that and I’ll try...

<Ožujsko> So perhaps the title of this blog is a little over the top, but I had a customer recently who needed help when their .mpp file became corrupt due to a VPN issue (I think the file was left open on the file server when...

<Leffe Blond> This requirement came from a customer more as a general query rather than a full demand, but I thought it should be an interesting enough problem to invest some time in. Changing the font, colour, or any of the other options available under Format |...

<Youngs bitter> A customer on a recent training course asked if how he could create a view that didn’t display dates, but rather showed the day number from the project start date, that each task started on. Depending on whether you want to include working days or...

G&T (Gordons) with a slice and ice…. If you’re using assignments for team members, you’ll have noticed that completed assignments still appear on the My Tasks page, even when the resource has updated the task and the task is 100% complete.  This causes confusion for resources,...

<Sauvignon Blanc Semillon> Several weeks ago a customer of mine was getting a fatal error with Project Professional 2007 when connecting to the server.  This was only happening on a single machine, and the usual re-installs/repairs didn’t fix a thing.  It so happened that the security...

During the lifetime of a project it is sometimes necessary to change the Project Manager (due to a leave of absence).  The process to do this has changed between 2003 and 2007.  There are three areas to be concerned with 1.  Changing the Project Manager; Changing the...