Loading...
Quick Links

Resource Availability Visual Report keeps crashing…how do I get the time-phased info out?

Home Forums Discussion Resource Availability Visual Report keeps crashing…how do I get the time-phased info out?

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #5165 Reply
    CommunityCommunity
    Keymaster

    Hi all

    I’m using Project Pro (SP1 & Cumulative patches installed; both Office and Project ‘repaired’ after it was a suggested fix) and am trying to pull the Resource Availability Visual Report into excel.

    I am using a Resource Pool with only 50 resources with about 6 plans connected to it. I also have a Master file created with all the .mpp files inserted as a sub-project. I have taken these files off the network and currently have them on a USB stick and access them via a laptop.

    ISSUE #1

    I get the following error FROM EXCEL:

    File system error: An error occurred while opening ‘D:DOCUME~1PKMACCTLocals~1Temp1Visual Reports Temporary Data{acdeafd6-f32c-4192-8d9e-b5ca6ac126a8}ResourceTP.cub’local cube file 

    All other reports can be created, though they are based on a 2003 template.

    I have tried replacing the 2003 template for this report with a 2010 version of the file, but my system simply recreated it and the report still pulls the .xlt file, not the new one.

    ISSUE #2

    In a desperate attempt to get something to work, I disconnected each plan from the Resource Pool and used the Master to create this report and it worked!

    Only problem is I now have duplicate entries for Resources assigned to multiple projects and cannot filter on projects. (I tried a custom field to bring the project names over but all it would return is a NULL value)

    I’ve also noticed this report is basing availability off of Max Units. This is an issue, since I schedule with 100% (or more when it’s a group) Max Units and have a modified Base Calendar. Is there any quick fix to this?

    Thanks in advance for any and all help provided!

    Shelley

Viewing 1 post (of 1 total)
Reply To: Resource Availability Visual Report keeps crashing…how do I get the time-phased info out?
Your information: