On 2012-10-23 21:39, Don Guillett wrote:
> On Tuesday, October 23, 2012 8:17:30 AM UTC-5, Lu Wei wrote:
>> When a query is returned, it inserts a new range of data making the old
>> data move rightward. But I want the new data just overwrite the existing
>> data, to avoid formula invalidity. Could it be done?
> Try clearing the existing data first
Clearing the existing data will not work, resulting the cleared blank
columns moved to right by query returned cells. Deleting the existing
data seems should work, but the referenced column in formula (in another
sheet) will become #REF! and cannot recover to original name after query.
PGP key ID: 0x92CCE1EA