MS Query and Row Range Names

[Marc]

We utilize MS queries in a spreadsheet that has range
names for rows. Unfortunately, when the query returns a
different # of records than before the query, it messes
up the reference of the range names (i.e. if row 123 is
named "Partner1" before the refresh of the
query, "Partner1" will not move with the associated row
if new records are inserted and/or deleted - NOR does it
stay at row 123). Does anybody know what is going on and
how to overcome this issue?

Thank you.

 

[Guest]

Correction to my original message, the range name does
stay at row 123 (i.e. absolute). But I have tried to use
relative references in my named ranges to no avail. Any
ideas???