Duplicating a sheet has doubled each resource usage

Nigel Pitts-Drake

I have created a sheet of activities and then allocated resources to each task as normal.

 

I then wanted to keep this sheet as is, as a template. I made a copy of this sheet to do some "what-ifs" scenarios on this sheet and keep the original intact.

 

However in the Resource View, each resource is picking up the utilisation from both the original and the copy and hence is "doubling up" and I'm seeing 200% everywhere

 

Is there a way of seeing just the resource usage from the copied "what-ifs" scenario sheet?     

Kennedy Stomps

Hi Nigel-- If you don't want allocation in a sheet to appear in your Resource Views (or to appear overallocated), you could disable Resource Management in the sheet you are using as a template. To do this, right-click any column header and select "Edit Project Settings", click the Resource Management tab on the left side of the window, and uncheck the box for Resource Management enabled. Hope this helps!

Nigel Pitts-Drake

Hi Kennedy.  Excellent! thanks for your help, it's very much appreciated.  I hadnt realised that if a sheet is copied, it also copies across Resource Management, hence the "doubling up" of allocation

Thnaks once again