D
Dean H.
I am using Excel 97 to get data from a Access 97 DB. When
I set the "Data layout" selection box of the External Data
Range Properties dialogue box to "Overwrite existing cells
with new data, clear unused cells" my data range works
just fine. The problem come when I save/close the
worksheet and then re-open. The "Data Layout" selection
box defaults to "Insert entire rows for new data, clear
unused cells" and subsequence data re-fresh causes a shift
in the cells below the data I am importing. Is there an
option or some way I can ensure that the External Data
Range Properties dialogue box defaults to "Overwrite
existing cells with new data, clear unused cells"?
Any help would be appreciated.
I set the "Data layout" selection box of the External Data
Range Properties dialogue box to "Overwrite existing cells
with new data, clear unused cells" my data range works
just fine. The problem come when I save/close the
worksheet and then re-open. The "Data Layout" selection
box defaults to "Insert entire rows for new data, clear
unused cells" and subsequence data re-fresh causes a shift
in the cells below the data I am importing. Is there an
option or some way I can ensure that the External Data
Range Properties dialogue box defaults to "Overwrite
existing cells with new data, clear unused cells"?
Any help would be appreciated.