I need to export resource units data from P6 into excel on up to 200 managed projects, and then need to re-import this modified resource/units data back to P6 v6.1 from Excel, once project managers have updated it. The import facility available to superusers only permits export/import for one project at a time, which is not practical in my case.
Is there a way of exporting/importing a single set of data (xls file or otherwise) which will update the relevant projects by way of unique references (Project and activity ID's). Have seen this type of thing done with Artemis Views - but not sure about P6.