a lot of "ExternalData" Named Ranges

S

s

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

deleting named ranges on a worksheet (not workbook) 5
Macro to Create Name Ranges for variable lengths of Data 9
Named Ranges vs. Constant Addresses, sheet protection, Guidance. 2
VBA Search Date Range and Populate Spreadsheet Cells 3
Copy A Named Range To a Different Sheet 4
Error in external named range 5
cannot expand named range 1
Sub to iterate thru combo box n copy paste n name ranges successively in a new sht 11

Top