Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Imported Data Not Replacing Existing Data - Excel 2007
Hello, In Excel 2007 we are trying to import an External Excel file into an existing workbook, however, when the data is brought over it simply shifts the old data to the right and places the new one to the left of the old data. We have tried to specify the entire worksheet range and it still pushes the old data to the right and the new one to the left. In Excel 2003 you were able to check replace existing data. Is this option still available in Excel 2007? Is there a way I can get the imported data to replace the old one? Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
prevent copied blank cells from replacing existing data | Excel Worksheet Functions | |||
How can Excel user preferences be imported from an existing PC? | Setting up and Configuration of Excel | |||
sorting on imported Data Excel 2007 | Excel Discussion (Misc queries) | |||
imported data into excel | Excel Worksheet Functions | |||
moving data in excel without deleting existing data | Excel Discussion (Misc queries) |