Hillary, I think you’ll want to open one or two different questions for these. 1. By “incorrect,” are you suggesting that the %work completes in the exported assignments are different from what you see in the task usage or resource usage table in Project? %work complete is calculated as (actual work)/(work) for the task and for each assignment.
2. Your original question is about exporting data from Project to Excel. Assuming conventions for data structure are followed, you can re-import modified data back into Project, but the data in Project and Excel are not dynamically linked. “Refresh All” in PWA implies a completely different process with which I’m not familiar. Good luck, tom