a lot of "ExternalData" Named Ranges
I'm having a problem with range names being created when I do Queries. They
all begin with ExternalData. I've found several references to this problem
in the archives, and there are suggested subroutines to remove these named
ranges, which I have successfully implemented.
But I wonder if I am doing something wrong in the way Microsoft intended
these Queries to work. Does everyone who uses queries just plug in a
routine to remove these ExternalData range names after their query? It sure
seems less than elegant, especially with a function that is so useful
(Queries).
Thanks for any help,
Dick Sanders
|