#1
|
|||
|
|||
Problem Uploading Excel to Replace Existing Data
Hi there,
Need some help, I have a master microsoft project with numerous subprojects linked to it. When I export the master to excel, do my INDEX/MATCH, and then re-upload using the merge mapping tool my new data goes to the end of my project rather than replace the existing. I am even using the unique ID mast my merge key and it still doesn't work. Can anyone help with what I am doing wrong? Thanks |
#2
|
|||
|
|||
you probably have to operate on the sub plans independently. What I suspect is happening is that when you copy the data back into the master it is doing precisely that - copying it into the open plan which is the master plan. If you want to copy the data into the sub plans you need to have them open and copy into them.
It maybe possible to do this from within the master by copying only the data for each sub plan into the specific "section" (i.e. plan) in the master document. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Problem uploading docx to gmail | aland | Word | 2 | 02-26-2019 05:06 PM |
Problem Linking Existing Powerpoint Graphs to data in Powerpivot | Xzzac | PowerPoint | 0 | 01-04-2017 12:35 PM |
use existing table data and not get generic excel chart data | canar | Word Tables | 3 | 09-08-2015 03:36 PM |
sending data from UserForm of existing excel file to a new excel file | saltlakebuffalo | Excel Programming | 0 | 02-13-2014 10:55 PM |
Copy Excel data into an existing Word Table | JJG | Word | 1 | 12-18-2013 05:41 PM |