Export to Excel weirdness

[Jim Elden]

Project Server 2003...

When I am on the Project Web Access page, and do Resources --> View Resource
Assignments -->Export Grid to Excel, I get different data in the Excel
spreadsheet than what is showing in the grid on the web page.

1) Tasks that have been deleted from projects are showing in Excel
2) Tasks where the rsource assignments have been changed are showing both
the new and the old asssignments (old assignments can't be found anywhere
else and we don't want them)

How can I fix this?

Thanks!

 

[Jim Elden]

OK, figured it out.

for 1) the task was showing in PWA with a "X" and "Task has been deleted"
Somehow these still export to excel without any indication of having been
deleted (Feature??).

So I did this in the Project SQL Server database to clean it up:

DELETE FROM MSP_WEB_ASSIGNMENTS
WHERE WASSN_DELETED_IN_PROJ = 1

There was no need for these deleted tasks to be on anyone's timesheets as
they just did not belong in the project. We're still new at ths...

2) I simply needed to republish the assignments and this got cleared up.