Export to Excel weirdness  
Index ‹ DotNet ‹ Microsoft Project
Author Message
Janter
PostPosted: Thu Jan 15 09:48:15 CST 2004 Top
Microsoft Project >> Export to Excel weirdness 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

DotNet12  
 
 
Jim
PostPosted: Thu Jan 15 09:48:15 CST 2004 Top
Microsoft Project >> Export to Excel weirdness 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.


--
Jim

"Jim Elden" <x@yz> wrote in message
news:O$EMail@HideDomain.com...
> 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
>
>


 
 
 
Index ‹ DotNet ‹ Microsoft Project