Explanation, has anyone seen this before? What is it? Is it an issue?

So I recently was beginning to make some changes to a workbook that I am constantly improving and seen something I have not seen before. I have numerous entries in the Excel Name Manager, somewhere in excess of approximately 170. I was beginning to make some changes and used the following code to dump a list of my name manager entries:

Please Login or Register  to view this content.

This adds a worksheet to your workbook where it shows the entries that you have. See the attached file. This snapshot is taken from almost the bottom of the list and shows over 7000+ entries listed as ImportBuffer!ExternalData_999 etc. Yet if I click on the Name Manager myself, I do not see any of these entries. So far, they seem to have no affect on my workbook and are related to Imports obviously.

I added the following code some time ago to remove connections that were increasing the file size and this has worked great:

Please Login or Register  to view this content.

So my questions are, has anyone seen these before? What are they? Are they a problem? and if so, How do I get rid of them?

This is not allowing me to attach the file directly, so I will post and then attach hopefully.

Not sure if the file will show or not?

I am very familiar with adding attachments via the Manage Attachments feature, but at the time of this post, that feature was not there. It only showed up after I posted and then I was able to add the attachment.

I am not sure what you mean by "Array formula should be confirmed with Ctrl+Shift+Enter keys together." What I have figured out is that all of these "ImportBuffer!ExternalData_1, etc" messages related to the sheet called ImportBuffer that is used when importing data. I clicked on the Data tab and then clicked on Queries and Connections and both show Zero. I did inspect the ImportBuffer sheet and found that columns A through AB had all minimized and were not initially visible. I have since added code that corrects this problem.

However, I still see those "ImportBuffer!ExternalData_1, etc" messages and again I am not sure where to find, where they are coming from or how to remove them.

I was not using a mobile device but was using my PC when making the post.

I did not post the workbook, I only posted a Picture of the ImportBuffer data that I see when running the ListAllNames routine. I cannot post the workbook since it contain large amounts of confidential data.

Thank you

I have found the problem and resolved the issue. The problem was caused by importing worksheets. I import about 15 worksheets when I Import data.
One particular import, imports up to 2000 line of data. Most of the others only import 45 to 105 lines of data.
Although inspecting the worksheet showed no specific data in cells, there is apparently some data left behind even though it is not visible. Using the Workbook Statistics button on the Review tab gave me the information found in the attached file.
The Current sheet in this case was the ImportBuffer sheet. I then inserted the following code into my import processes:

Please Login or Register  to view this content.

which clears all cells in the worksheet

Now if I run the ListAllNames routine it no longer shows the messages of concern. Even though this at the time did not seem to cause any problems it was accumulating some remains in the ImportBuffer sheet and had grown to over 7000 lines in multiple columns.

It is best to be proactive and resolve issues before they present themselves as a problem.

Thanks everyone for your messages and suggestions. I will now mark this post as resolved.

PS, After resolving this issue my file size was reduced from 3216KB to 1301KB !!!