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.