Two new question, now that it works in Excel:
For example: one task has 2 resources assigned Mary Smith and John Jones.
1. In Excel under the summary level task, the next row has all the resource names on it with their % work complete but those numbers are incorrect. Is MS Project calculating that % work complete differently
2. The customer is using PWA. How can I get this to be a Refresh All and update this data from PWA into Excel and then just hit Data\ Refresh All?
If you want me to start a new discussion thread for the second question, just let me know.