Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-08-2021, 05:11 AM
MichaelM2021 MichaelM2021 is offline Problem Uploading Excel to Replace Existing Data Windows 10 Problem Uploading Excel to Replace Existing Data Office 2016
Novice
Problem Uploading Excel to Replace Existing Data
 
Join Date: May 2021
Posts: 6
MichaelM2021 is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 05-09-2021, 04:17 AM
miless2111s miless2111s is offline Problem Uploading Excel to Replace Existing Data Windows 7 32bit Problem Uploading Excel to Replace Existing Data Office 2007
Advanced Beginner
 
Join Date: May 2016
Posts: 32
miless2111s is on a distinguished road
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


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
Problem Uploading Excel to Replace Existing Data 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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:56 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft