When I go to project center in PWA and the go to reports tab and open the report in question once it loads I have to edit it in excel to refresh the connections. When I pull it into excel and try to follow the steps you laid out above I get as far as Data/ and then everything is greyed out like the workbook is protected. IT guys says no. I have even tried to save to my machine and I hit the same wall. Any ideas?
Also I have been volentold to get a working set of reports complete this month. I have the basic structure in place and I can pull a lot of the data but really have no idea how to get to the point of making counts by person, late delievery by person etc… If you have any advice or ideas of a good resource to walk me thru creating these reports it would be a huge help.