ExternalData_1 when importing CSV to workbook

Logically thinking:

I do not need any connections and external data after importing CSV using presented method above.
Query tables can not be refreshed after using importing code like that.
can anybody confirm?

So should I delete connection created and also named range created?
If Yes how to do this?

After deleting named range query table has no connection inside in VBA code and this part of code causes error:

Please Login or Register  to view this content.

I am getting queryTable is not valid.

When i deleted WorkbookConnection i am getting error: Workbook Connection has been deleted.

How to do it properly?

p.s. powerquery is not solution for me here because i would have to build queries formulas on the fly from code and this works only from 2016 Excel

Please help,
Jacek

Your cross post appears to be to this thread rather than another thread on another board.

I have noticed this before -- that Excel creates names in the name manager for these text/data imports. My only explanation is that it is a necessary part of Excel's internal architecture for dealing with these data import query tables. As one who never really uses named ranges, this hasn't impacted my work in Excel because Excel can just manage these names in the background without getting in my way. In those workbooks where I have multiple text imports/query tables, I go to extra lengths to avoid the name manager.

What is your concern with these "unnecessary" names? In my work, those "extra" names have never interfered in my work. On rare occasions when I open the name manager, I find the name manager cluttered and difficult to sort out real, useful names and these Excel created names, but that is the only time it has been a concern to me (and it is rare for me to open the name manager).

What do you mean go with extra lenghts?

I just mean I never open the name manager and avoid using named ranges in those workbooks.

But what about connection created (queries and connections tab in ribbon)? Do you create them? Or always delete after importing?

I don't do anything with them. Perhaps it is my inexperience with them, but I usually find the queries and connections command/dialog to be pretty useless, so I've learned never to mess with it. I just let Excel manage query names and definitions behind the scenes.

Are you having a specific problem that is caused by these names? Perhaps if you explain what has led to posing this question, those with more experience can comment on what you are really trying to do.