Portfolio Analyzer to Excel

R

Rob

Curious if anyone has had problems exporting to excel from PA.
Basically I have 3 projects, 7 resources, resource types[2], and resource
vendor names [9] in the criteria.
No matter what I change in the criteria or view, the query never finishes in
excel.
Does this sound like an Hardware/Network issue or more of a software issue
though I am not getting any errors?
Now this takes place on different views not just one view but 12-15
different views. Other views do come up with the same type of criteria just
curious why the others do not.
 
M

Manmeet Chaudhari

Hi
Try making your macro security level low in Excel.
Also in Internet Explorer under tools select internet options
Click on security
Select local intranet or internet where ever your project server is hosted
Click on custom level
Make sure Download signed active x controls is set to prompt or enable

Let me know if it works

Regards
Manmeet Chaudhari
 
Top