Hey everyone, I’m hoping someone can help. I’m trying to set up a data import from a table in one workbook to one laid out exactly the same in another. However when I try to set up the link for the first time it’s inserting new cells rather than populating the existing table. I know once the data is in I can choose to format data import and choose the option to reuse the existing cells rather than inserting new cells. But I can’t seem to do it until it’s already in place.
This is a problem as there are formula that are pointed at the existing table’s lay out. I’m going to need to rebuild these workbooks as I’ve inherited them and they do suck quite a bit but I really don’t have time to completely rebuild everything in this version.
I’m using Excel 2010. Is there anyway I can specify that the data is only inserted into the existing cells before the link is made?
Thanks guys
This is a problem as there are formula that are pointed at the existing table’s lay out. I’m going to need to rebuild these workbooks as I’ve inherited them and they do suck quite a bit but I really don’t have time to completely rebuild everything in this version.
I’m using Excel 2010. Is there anyway I can specify that the data is only inserted into the existing cells before the link is made?
Thanks guys